diff options
| author | Nick Kallen <nkallen@nick-kallens-computer-2.local> | 2008-01-03 23:41:43 -0800 |
|---|---|---|
| committer | Nick Kallen <nkallen@nick-kallens-computer-2.local> | 2008-01-03 23:41:43 -0800 |
| commit | a5d62729799ed58ce344dba0621e951dbc92ab3f (patch) | |
| tree | 11e3b9f32b649c32d5e7b84f4546c835e6a29b2e | |
| parent | 6c89e3818d85e3169a7fb8de27b25357c2259881 (diff) | |
| download | rails-a5d62729799ed58ce344dba0621e951dbc92ab3f.tar.gz rails-a5d62729799ed58ce344dba0621e951dbc92ab3f.tar.bz2 rails-a5d62729799ed58ce344dba0621e951dbc92ab3f.zip | |
new usage of builder
`
25 files changed, 1853 insertions, 130 deletions
diff --git a/eager include.txt b/eager include.txt new file mode 100644 index 0000000000..0c56323b40 --- /dev/null +++ b/eager include.txt @@ -0,0 +1,49 @@ +User.find( :all, :include => { :photos => :camera } ) + +User.reflection[:photos].klass.reflection[:camera] + +users_photos_camera = User.relation << User.reflections[:photos].relation << Photo.reflections[:camera].relation + +users_photos_camera.each do |record| + User.bring_forth(record, :photos => :camera) +end + +def User.bring_forth(record, included = { :photos => :camera }) + user = @cache[ record % 'users.id' ] || User.instantiate(record % User.attributes) + user.photos.bring_forth(record, :camera) +end + +def User.photos.bring_forth(record, included = :camera) + photo = @cache[ record % 'photos.id' ] || Photo.instantiate(record % Photo.attributes) + photo.camera.bring_forth(record) +end + +def User.photos.camera.bring_forth(record, included = nil) + camera = @cache [ record % 'cameras.id' ] || Camera.instantiate(record % Camera.attributes) +end + +########################### + +# first, rename the attributes to remove ambiguity (analogous to c0_t0 stuff) +eager_loaded_user_cameras = @user_cameras.rename( + @user.attributes => @user.attributes.prefixed, + @photos.attributes => ..., + @cameras.attributes => ..., +) + +# second, bring forth!! +class Repository + def bring_forth(record, includes = []) + object = cache.get(record % klass.primary_key) { Klass.instantiate(record % Klass.attributes) } + includes.each do |include| + case include + when Symbol + object.send(association = include).bring_forth(record) + when Hash + include.each do |association, nested_associations| + object.send(association).bring_forth(record, nested_associations) + end + end + end + end +end
\ No newline at end of file diff --git a/lib/sql_algebra.rb b/lib/sql_algebra.rb index 5753a48d2f..b3e3c8d176 100644 --- a/lib/sql_algebra.rb +++ b/lib/sql_algebra.rb @@ -1,8 +1,10 @@ $LOAD_PATH.unshift(File.dirname(__FILE__)) require 'rubygems' -require 'active_support' +require 'activesupport' +require 'activerecord' require 'sql_algebra/relations/relation' +require 'sql_algebra/relations/compound_relation' require 'sql_algebra/relations/table_relation' require 'sql_algebra/relations/join_operation' require 'sql_algebra/relations/inner_join_operation' @@ -15,6 +17,7 @@ require 'sql_algebra/relations/projection_relation' require 'sql_algebra/relations/selection_relation' require 'sql_algebra/relations/order_relation' require 'sql_algebra/relations/range_relation' +require 'sql_algebra/relations/join' require 'sql_algebra/predicates/predicate' require 'sql_algebra/predicates/binary_predicate' @@ -30,7 +33,6 @@ require 'sql_algebra/predicates/match_predicate' require 'sql_algebra/extensions/range' require 'sql_algebra/extensions/object' -require 'sql_algebra/sql_builder/sql_builder_adapter' require 'sql_algebra/sql_builder/sql_builder' require 'sql_algebra/sql_builder/select_builder' require 'sql_algebra/sql_builder/joins_builder' diff --git a/lib/sql_algebra/extensions/base.rb b/lib/sql_algebra/extensions/base.rb new file mode 100644 index 0000000000..79f2ce75d1 --- /dev/null +++ b/lib/sql_algebra/extensions/base.rb @@ -0,0 +1,15 @@ +class ActiveRecord::Base + def self.bring_forth(record, includes = []) + object = cache.get(record % klass.primary_key) { Klass.instantiate(record % Klass.attributes) } + includes.each do |include| + case include + when Symbol + object.send(association = include).bring_forth(record) + when Hash + include.each do |association, nested_associations| + object.send(association).bring_forth(record, nested_associations) + end + end + end + end +end
\ No newline at end of file diff --git a/lib/sql_algebra/extensions/object.rb b/lib/sql_algebra/extensions/object.rb new file mode 100644 index 0000000000..639e810a97 --- /dev/null +++ b/lib/sql_algebra/extensions/object.rb @@ -0,0 +1,8 @@ +class Object + def to_sql(builder = EqualsConditionBuilder.new) + me = self + builder.call do + value me + end + end +end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/inner_join_relation.rb b/lib/sql_algebra/relations/inner_join_relation.rb index 1ef965a6f5..6b932e3b21 100644 --- a/lib/sql_algebra/relations/inner_join_relation.rb +++ b/lib/sql_algebra/relations/inner_join_relation.rb @@ -1,5 +1,5 @@ class InnerJoinRelation < JoinRelation - def join_name + def join_type :inner_join end end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/join_relation.rb b/lib/sql_algebra/relations/join_relation.rb index b96cd175de..dc57e24c96 100644 --- a/lib/sql_algebra/relations/join_relation.rb +++ b/lib/sql_algebra/relations/join_relation.rb @@ -11,24 +11,22 @@ class JoinRelation < Relation (relation2 == other.relation1 and relation1 == other.relation2)) end - def to_sql(builder = SelectBuilder.new) - relation2.to_sql(translate_from_to_inner_join_on_predicates(relation1.to_sql(builder))) + def joins + relation1.joins + relation2.joins + [Join.new(relation1, relation2, predicates, join_type)] end - private - # translate 'from' to 'inner join on <predicates>' - def translate_from_to_inner_join_on_predicates(builder) - schmoin_name, schmredicates = join_name, predicates - SqlBuilderAdapter.new(builder) do |builder| - define_method :from do |table| - builder.call do - send(schmoin_name, table) do - schmredicates.each do |predicate| - predicate.to_sql(self) - end - end - end - end - end + def selects + relation1.selects + relation2.selects end + + def attributes + relation1.attributes + relation2.attributes + end + + def attribute(name) + relation1[name] || relation2[name] + end + + protected + delegate :table, :to => :relation1 end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/left_outer_join_relation.rb b/lib/sql_algebra/relations/left_outer_join_relation.rb index c7722c394d..f4ece43861 100644 --- a/lib/sql_algebra/relations/left_outer_join_relation.rb +++ b/lib/sql_algebra/relations/left_outer_join_relation.rb @@ -1,5 +1,5 @@ class LeftOuterJoinRelation < JoinRelation - def join_name + def join_type :left_outer_join end end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/relation.rb b/lib/sql_algebra/relations/relation.rb index bd812b368d..8c21927d01 100644 --- a/lib/sql_algebra/relations/relation.rb +++ b/lib/sql_algebra/relations/relation.rb @@ -1,34 +1,65 @@ class Relation - def <=>(other) - InnerJoinOperation.new(self, other) - end + module Operations + def <=>(other) + InnerJoinOperation.new(self, other) + end - def <<(other) - LeftOuterJoinOperation.new(self, other) - end + def <<(other) + LeftOuterJoinOperation.new(self, other) + end - def [](index) - case index - when Symbol - Attribute.new(self, index) - when Range - RangeRelation.new(self, index) + def [](index) + case index + when Symbol + attribute(index) + when Range + RangeRelation.new(self, index) + end end - end - def include?(attribute) - RelationInclusionPredicate.new(attribute, self) - end + def include?(attribute) + RelationInclusionPredicate.new(attribute, self) + end - def select(*predicates) - SelectionRelation.new(self, *predicates) + def select(*predicates) + SelectionRelation.new(self, *predicates) + end + + def project(*attributes) + ProjectionRelation.new(self, *attributes) + end + + def order(*attributes) + OrderRelation.new(self, *attributes) + end end + include Operations - def project(*attributes) - ProjectionRelation.new(self, *attributes) + def connection + ActiveRecord::Base.connection end - def order(*attributes) - OrderRelation.new(self, *attributes) + def to_sql(builder = SelectBuilder.new) + builder.call do + select do + attributes.each { |a| a.to_sql(self) } + end + from table do + joins.each { |j| j.to_sql(self) } + end + where do + selects.each { |s| s.to_sql(self) } + end + order_by do + orders.each { |o| o.to_sql(self) } + end + end end + + protected + def attributes; [] end + def joins; [] end + def selects; [] end + def orders; [] end + end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/selection_relation.rb b/lib/sql_algebra/relations/selection_relation.rb index 51461de7d2..72911aa65a 100644 --- a/lib/sql_algebra/relations/selection_relation.rb +++ b/lib/sql_algebra/relations/selection_relation.rb @@ -1,4 +1,4 @@ -class SelectionRelation < Relation +class SelectionRelation < CompoundRelation attr_reader :relation, :predicate def initialize(relation, *predicates) @@ -10,13 +10,7 @@ class SelectionRelation < Relation relation == other.relation and predicate == other.predicate end - def to_sql(builder = SelectBuilder.new) - relation.to_sql(builder).call do - where do - predicate.to_sql(self) - end - end + def selects + [predicate] end - - delegate :[], :to => :relation end
\ No newline at end of file diff --git a/lib/sql_algebra/relations/table_relation.rb b/lib/sql_algebra/relations/table_relation.rb index 60bdfda8ee..1915b42565 100644 --- a/lib/sql_algebra/relations/table_relation.rb +++ b/lib/sql_algebra/relations/table_relation.rb @@ -5,10 +5,19 @@ class TableRelation < Relation @table = table end - def to_sql(builder = SelectBuilder.new) - builder.call do - select { all } - from table + def attributes + attributes_by_name.values + end + + protected + def attribute(name) + attributes_by_name[name.to_s] + end + + private + def attributes_by_name + @attributes_by_name ||= connection.columns(table, "#{table} Columns").inject({}) do |attributes_by_name, column| + attributes_by_name.merge(column.name => Attribute.new(self, column.name.to_sym)) end end end
\ No newline at end of file diff --git a/lib/sql_algebra/sql_builder/order_builder.rb b/lib/sql_algebra/sql_builder/order_builder.rb new file mode 100644 index 0000000000..4eea40fa36 --- /dev/null +++ b/lib/sql_algebra/sql_builder/order_builder.rb @@ -0,0 +1,16 @@ +class OrderBuilder < SqlBuilder + def initialize(&block) + @orders = [] + super(&block) + end + + def column(table, column, aliaz = nil) + @orders << (aliaz ? aliaz : "#{table}.#{column}") + end + + def to_s + @orders.join(', ') + end + + delegate :blank?, :to => :@orders +end
\ No newline at end of file diff --git a/lib/sql_algebra/sql_builder/selects_builder.rb b/lib/sql_algebra/sql_builder/selects_builder.rb new file mode 100644 index 0000000000..72f6f52397 --- /dev/null +++ b/lib/sql_algebra/sql_builder/selects_builder.rb @@ -0,0 +1,20 @@ +class SelectsBuilder < SqlBuilder + def initialize(&block) + @selects = [] + super(&block) + end + + def to_s + @selects.join(', ') + end + + def all + @selects << :* + end + + def column(table, column, aliaz = nil) + @selects << "#{table}.#{column}" + (aliaz ? " AS #{aliaz}" : '') + end + + delegate :blank?, :to => :@selects +end
\ No newline at end of file diff --git a/lib/sql_algebra/sql_builder/sql_builder_adapter.rb b/lib/sql_algebra/sql_builder/sql_builder_adapter.rb deleted file mode 100644 index 9bb5271f33..0000000000 --- a/lib/sql_algebra/sql_builder/sql_builder_adapter.rb +++ /dev/null @@ -1,22 +0,0 @@ -class SqlBuilderAdapter - instance_methods.each { |m| undef_method m unless m =~ /^__|^instance_eval|class/ } - - def initialize(adaptee, &block) - @adaptee = adaptee - (class << self; self end).class_eval do - (adaptee.methods - instance_methods).each { |m| delegate m, :to => :@adaptee } - end - (class << self; self end).instance_exec(@adaptee, &block) - end - - def call(&block) - @caller = eval("self", block.binding) - returning self do |adapter| - instance_eval(&block) - end - end - - def method_missing(method, *args, &block) - @caller.send(method, *args, &block) - end -end
\ No newline at end of file diff --git a/spec/debug.log b/spec/debug.log new file mode 100644 index 0000000000..d38ed11d82 --- /dev/null +++ b/spec/debug.log @@ -0,0 +1 @@ +# Logfile created on Tue Jan 01 17:49:28 -0800 2008 by logger.rb/1.5.2.9 diff --git a/spec/integration/debug.log b/spec/integration/debug.log new file mode 100644 index 0000000000..9b5b08cc20 --- /dev/null +++ b/spec/integration/debug.log @@ -0,0 +1,1581 @@ +# Logfile created on Tue Jan 01 18:37:24 -0800 2008 by logger.rb/1.5.2.9 + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010719)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002219)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001538)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002551)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001835)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010748)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002223)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002938)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002466)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001493)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000116)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010722)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002196)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001528)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001373)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001372)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001599)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.012868)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001681)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002253)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002186)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010737)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002277)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001517)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001368)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001481)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010719)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002651)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001464)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001504)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010820)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002194)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001565)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001282)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010719)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002103)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001468)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001526)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010648)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002458)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001525)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001571)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001274)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001527)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000130)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010705)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002444)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001608)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001488)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001462)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001492)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.015956)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.001676)[0m [0;1mSHOW TABLES[0m + [4;35;1mUser Columns (0.001593)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000144)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010771)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002480)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001474)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001357)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.011769)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001586)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000232)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000120)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010804)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002188)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001478)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001550)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001413)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001515)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000251)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010826)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002353)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001500)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001522)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001438)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001436)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000266)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001396)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010772)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002268)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001566)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001390)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001466)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001600)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000247)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010742)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002382)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001490)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001505)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001846)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001491)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010798)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002447)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001557)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001387)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001469)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001394)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010727)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002213)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001491)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001407)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001457)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001529)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000247)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000320)[0m [0;1mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000135)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010663)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002319)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001467)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001319)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.010583)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001805)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000290)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000271)[0m [0;1mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010733)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002277)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001500)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001387)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001421)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001726)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000261)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000261)[0m [0;1mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001432)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000134)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010759)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002287)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001424)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001550)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001342)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001545)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001488)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000249)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000290)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000139)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010766)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002183)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001465)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001492)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.012690)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001591)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001740)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000261)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000262)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000110)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010751)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002343)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001476)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001513)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001495)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001569)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001497)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000249)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.028671)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010774)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002229)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001532)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001526)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001463)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001558)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001479)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000253)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000248)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000141)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010731)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002167)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001370)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001523)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001275)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001480)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001193)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000228)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000228)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011242)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001695)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001744)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001452)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001419)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001378)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002561)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000923)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000275)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000157)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010515)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002311)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002045)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001878)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001586)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001397)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001944)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000453)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000283)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010759)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002066)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001582)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001459)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001418)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001367)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001849)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001231)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000357)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010706)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002375)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001616)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001826)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001508)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001638)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001719)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001674)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000337)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000114)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010717)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002698)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001432)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001686)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001403)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001809)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001590)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000540)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000341)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010746)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002455)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001483)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001588)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001513)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001247)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001527)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000227)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000252)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000142)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010735)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002400)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001299)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001451)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001173)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001530)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001793)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010758)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002271)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001485)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001578)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001492)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001389)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001391)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000249)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000170)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010733)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002313)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001469)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001593)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001511)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001484)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001478)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000232)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010796)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001970)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001558)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001440)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001354)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001544)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001405)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000239)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000111)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010751)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002354)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001463)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001588)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001505)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001464)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001509)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000235)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000133)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010651)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002468)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001364)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001503)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001543)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001452)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001445)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000228)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.330787)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002584)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001456)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001621)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001475)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001481)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001552)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000226)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000144)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010706)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002394)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001322)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001656)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001495)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001498)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001510)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000222)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010785)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002249)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001469)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001410)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001666)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001627)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002215)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000942)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000149)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010774)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001649)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001497)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001457)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001345)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001298)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001849)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000967)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000143)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010724)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002360)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001570)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001733)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001624)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001840)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001080)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010885)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002106)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001603)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001575)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001529)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001517)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001556)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000260)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010689)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002034)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001430)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001590)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001434)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001543)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001597)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001103)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000143)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010735)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002171)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001553)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001586)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001520)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001441)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001560)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001796)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010772)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002291)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001505)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001466)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002032)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001543)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001434)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010845)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002185)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001479)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001551)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001459)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001521)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001392)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000222)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM photos [0m + [4;35;1mSQL (0.000246)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000136)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010662)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002267)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001467)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001437)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001355)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001506)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.012944)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000256)[0m [0;1mSELECT * +FROM photos [0m + [4;35;1mSQL (0.000271)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010682)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002485)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001454)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001588)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001480)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001539)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001735)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000111)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010744)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002250)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001491)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001534)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001499)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001482)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001496)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000165)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010840)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002301)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001598)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001456)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001241)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001479)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000887)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000137)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010721)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002243)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001485)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001592)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001519)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001480)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001534)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010748)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002303)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001459)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001580)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001584)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001507)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001526)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000139)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001564)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001517)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001405)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001516)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001704)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001583)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001579)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000135)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010720)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002156)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001639)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001434)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001357)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001513)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001474)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010719)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002256)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001531)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001453)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001388)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001494)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001101)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000219)[0m [0;1mSELECT users.id +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000157)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011477)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002257)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001520)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001410)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001383)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001505)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001462)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000222)[0m [0;1mSELECT users.id +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000197)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010701)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002382)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001523)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001558)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001494)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001467)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001516)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000129)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010711)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002382)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001495)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001445)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001363)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001557)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001433)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000000)[0m [0;1mMysql::Error: Unknown column 'photos.id' in 'field list': SELECT photos.id +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000132)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010902)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002079)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001455)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001626)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.012539)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001557)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001437)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000255)[0m [0;1mSELECT users.id +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000225)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010766)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002370)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001453)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001556)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001492)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001243)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001527)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000151)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010730)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002308)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001489)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001571)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001345)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001456)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001161)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000215)[0m [0;1mSELECT users.id +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000261)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000139)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010683)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002298)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001478)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001413)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001521)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001462)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001509)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001637)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000136)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010714)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002255)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001471)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001491)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001494)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001537)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001500)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000144)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010658)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002047)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001307)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001529)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001380)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001558)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000851)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000135)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010643)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002531)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001449)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001423)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001522)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001515)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001581)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010786)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002348)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001476)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001604)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001380)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001484)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001383)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000117)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010702)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002339)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001304)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001578)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001470)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001524)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001554)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000144)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010746)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002433)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001489)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001530)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001540)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001528)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001524)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000393)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000149)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010676)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002224)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001456)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001773)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001509)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001473)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001511)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000274)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010825)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002358)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001492)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001578)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001702)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001495)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001778)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000348)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000113)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010701)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002380)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001329)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001403)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001409)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001458)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001486)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000562)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000134)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010761)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002300)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001565)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001514)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001377)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001553)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001454)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000319)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000156)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010664)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002495)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001454)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001569)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001277)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001250)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001543)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000263)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000143)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010756)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002397)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001731)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001443)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001366)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001472)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001420)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010705)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002368)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001556)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001472)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001455)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001475)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002127)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001414)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010742)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002380)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001634)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001587)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001452)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001454)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001514)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000135)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010668)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002191)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001521)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001418)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001330)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001474)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001406)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010693)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002296)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001485)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001604)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001479)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001660)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001632)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010678)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002302)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001501)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001360)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001353)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001562)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001542)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000147)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010704)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002335)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001425)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001468)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001469)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001573)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001489)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010787)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002303)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001529)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001689)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001503)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001463)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000149)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010737)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002412)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001547)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001571)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001482)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001395)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000481)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010918)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001957)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001485)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001498)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001374)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001461)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001923)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000233)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000232)[0m [0mSELECT photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011208)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002172)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001453)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001526)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001666)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001273)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001845)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000270)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mSQL (0.000133)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010785)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002207)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001480)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001563)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001459)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001206)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001250)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000224)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000227)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000192)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010546)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002397)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002065)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001381)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.000979)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001410)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001516)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000216)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000240)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010781)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002045)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001462)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001712)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001383)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001934)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001974)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000277)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000266)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010789)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002174)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001549)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001406)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001380)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001590)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001465)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000236)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000260)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000148)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010729)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002288)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001373)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001594)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001516)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001470)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001653)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000249)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000324)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010695)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002188)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001450)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001569)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001437)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001780)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002270)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001585)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000325)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000151)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010721)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002947)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001515)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001270)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001479)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001428)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001953)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000253)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000279)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010670)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002111)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001460)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001578)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001576)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001497)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001326)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000235)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000250)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001613)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001535)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001418)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001545)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001536)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001527)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001497)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000230)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000227)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000134)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011304)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002381)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001508)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001665)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001498)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001503)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001514)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000225)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000231)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000134)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010747)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002111)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001510)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001581)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001428)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001507)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001808)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000247)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000237)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010702)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002320)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001504)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001589)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001555)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.002636)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001766)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000239)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000281)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000115)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011377)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002266)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001512)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001553)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001686)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001487)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001520)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.000223)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000233)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000133)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.011494)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002092)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001556)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001490)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001594)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001273)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001512)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001362)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001476)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000227)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000335)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.001514)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001589)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001412)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000110)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010696)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002449)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001558)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001720)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001577)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001420)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.009109)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001770)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001409)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000247)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000305)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001429)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001503)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001595)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001775)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000137)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010741)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002217)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001614)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001277)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001394)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001412)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001534)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001595)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001771)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000246)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000287)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.001537)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001578)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001351)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000124)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010755)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002276)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001312)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.002071)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001613)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001271)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001665)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001605)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001360)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000247)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000303)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001449)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001510)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001413)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001546)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000115)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001542)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001224)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001201)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001325)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001269)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001364)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001517)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001422)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001674)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000270)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000269)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.008183)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mPhoto Columns (0.001576)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001595)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001461)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001327)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000129)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001503)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001544)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001444)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001509)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001593)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001422)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001996)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001380)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000275)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000279)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001516)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001449)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001558)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001347)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000133)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010735)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002173)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001449)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001510)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001410)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001592)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001570)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001423)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001301)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000287)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000301)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001475)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mPhoto Columns (0.001465)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001633)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001467)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001332)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000132)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010888)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002202)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001500)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001457)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001593)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001424)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001492)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001520)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001480)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000290)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000263)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000320)[0m [0;1mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001896)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001262)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001675)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001409)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000130)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010691)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002363)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001590)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001560)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.013103)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001597)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001491)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001553)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001368)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000300)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.001508)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001583)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001442)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000132)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010756)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002320)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001416)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001507)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.012716)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001406)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001353)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001440)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001263)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000233)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000259)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001394)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001837)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001501)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001575)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001415)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001483)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000820)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001526)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001093)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001526)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001631)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001346)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000282)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mSQL (0.000281)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001235)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mPhoto Columns (0.001422)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001607)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001685)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001318)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010894)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002240)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001487)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001578)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001582)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001418)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001528)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001577)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001215)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000251)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001387)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000296)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001457)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001421)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001431)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001485)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000145)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010759)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002325)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001391)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001545)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001442)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001285)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001287)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001565)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001098)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000215)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001362)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000283)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001459)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001404)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001554)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001531)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000146)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010611)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002560)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001457)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001439)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001575)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001422)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001475)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001563)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001389)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000213)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001375)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000251)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001417)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001395)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001539)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001552)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000113)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010659)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002496)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001466)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001519)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001591)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001455)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001502)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001543)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001432)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000225)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001376)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000266)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001440)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001105)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001152)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001384)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000127)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010753)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002275)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001708)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001413)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001552)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001604)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001482)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001500)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001349)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000227)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001386)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000269)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001425)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001065)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001438)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001376)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000107)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010766)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002300)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001306)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001562)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001725)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001356)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001539)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001465)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001345)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000303)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001553)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000299)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001329)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001422)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001414)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001429)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.000349)[0m [0mSELECT * +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id LEFT OUTER JOIN cameras ON photos.camera_id = cameras.id +WHERE users.id = 1[0m + [4;36;1mSQL (0.000109)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010688)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002247)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001542)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001432)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001390)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001428)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001641)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001602)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001426)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000253)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001398)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000304)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001457)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001298)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001539)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001487)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000139)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.001575)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001596)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001406)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001432)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001640)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001465)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001463)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001577)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001434)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000258)[0m [0;1mSELECT * +FROM users +WHERE users.id = 1[0m + [4;35;1mUser Columns (0.001417)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.000338)[0m [0;1mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;35;1mPhoto Columns (0.001542)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001474)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001582)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001524)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000112)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.016053)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001843)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001493)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001376)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001547)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001670)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001504)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001756)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001567)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001476)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001574)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001402)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001565)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001346)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001424)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001447)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001570)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001502)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.000244)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001413)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000304)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mPhoto Columns (0.001471)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.034694)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001709)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001407)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000109)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010677)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002292)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001455)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001467)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001537)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001429)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001476)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001679)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001440)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001147)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001687)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001424)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001509)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001622)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001417)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001430)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001540)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001420)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.000244)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001374)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000288)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mPhoto Columns (0.001449)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.034463)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001751)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.002051)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000108)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010738)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002251)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001306)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001717)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001554)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001364)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001622)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001490)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001310)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001666)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002175)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001601)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001647)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002284)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001156)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001447)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001549)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001431)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.000391)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001439)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000284)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mPhoto Columns (0.001431)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.036129)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001678)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001446)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000111)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010686)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002498)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001549)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001496)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001586)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001451)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001455)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001648)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001364)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001406)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001501)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001399)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001388)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001888)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001454)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001570)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.002665)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001922)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001160)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001117)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001219)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mPhoto Columns (0.001255)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.034678)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001684)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001242)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.000110)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m + [4;35;1mSQL (0.010673)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002380)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001444)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001580)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001158)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001358)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.002625)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002378)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001774)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.002249)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001218)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.002117)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.001795)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.002656)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001412)[0m [0mSHOW FIELDS FROM `cameras`[0m + [4;36;1mSQL (0.001415)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.001519)[0m [0mSHOW FIELDS FROM `photos`[0m + [4;36;1mSQL (0.001043)[0m [0;1mSHOW FIELDS FROM `cameras`[0m + [4;35;1mSQL (0.000346)[0m [0mSELECT * +FROM users +WHERE users.id = 1[0m + [4;36;1mUser Columns (0.001560)[0m [0;1mSHOW FIELDS FROM `users`[0m + [4;35;1mSQL (0.000297)[0m [0mSELECT photos.user_id, photos.camera_id, photos.id +FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id +WHERE users.id = 1[0m + [4;36;1mPhoto Columns (0.001471)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001420)[0m [0mSHOW FIELDS FROM `users`[0m + [4;36;1mSQL (0.001463)[0m [0;1mSHOW FIELDS FROM `photos`[0m + [4;35;1mSQL (0.001395)[0m [0mSHOW FIELDS FROM `cameras`[0m diff --git a/spec/integration/scratch_spec.rb b/spec/integration/scratch_spec.rb index 6426d2478d..12832c1162 100644 --- a/spec/integration/scratch_spec.rb +++ b/spec/integration/scratch_spec.rb @@ -2,27 +2,17 @@ require File.join(File.dirname(__FILE__), '..', 'spec_helper') describe 'Relational Algebra' do before do - User = TableRelation.new(:users) - Photo = TableRelation.new(:photos) - Camera = TableRelation.new(:cameras) - user = User.select(User[:id] == 1) - @user_photos = (user << Photo).on(user[:id] == Photo[:user_id]) + @users = TableRelation.new(:users) + @photos = TableRelation.new(:photos) + @cameras = TableRelation.new(:cameras) + @user = @users.select(@users[:id] == 1) + @user_photos = (@user << @photos).on(@user[:id] == @photos[:user_id]) + @user_cameras = (@user_photos << @cameras).on(@user_photos[:camera_id] == @cameras[:id]) end it 'simulates User.has_many :photos' do - @user_photos.to_sql.should == SelectBuilder.new do - select { all } - from :users do - left_outer_join :photos do - equals { column :users, :id; column :photos, :user_id } - end - end - where do - equals { column :users, :id; value 1 } - end - end - @user_photos.to_sql.to_s.should be_like(""" - SELECT * + @user_photos.project(*@photos.attributes).to_sql.to_s.should be_like(""" + SELECT photos.id, photos.user_id, photos.camera_id FROM users LEFT OUTER JOIN photos ON users.id = photos.user_id @@ -31,7 +21,16 @@ describe 'Relational Algebra' do """) end - it 'simulating a User.has_many :cameras :through => :photos' do - user_cameras = (@user_photos << Camera).on(@user_photos[:camera_id] == Camera[:id]) + it 'simulates a User.has_many :cameras :through => :photos' do + @user_cameras.project(*@cameras.attributes).to_sql.to_s.should be_like(""" + SELECT cameras.id + FROM users + LEFT OUTER JOIN photos + ON users.id = photos.user_id + LEFT OUTER JOIN cameras + ON photos.camera_id = cameras.id + WHERE + users.id = 1 + """) end end
\ No newline at end of file diff --git a/spec/relations/attribute_spec.rb b/spec/relations/attribute_spec.rb index 5ddbaa96b5..d8a007f918 100644 --- a/spec/relations/attribute_spec.rb +++ b/spec/relations/attribute_spec.rb @@ -57,6 +57,7 @@ describe Attribute do end end + describe '#to_sql' do it "manufactures a column" do Attribute.new(@relation1, :attribute_name, :alias).to_sql.should == SelectsBuilder.new do diff --git a/spec/relations/join_relation_spec.rb b/spec/relations/join_relation_spec.rb index a7c15fd76a..bae294440e 100644 --- a/spec/relations/join_relation_spec.rb +++ b/spec/relations/join_relation_spec.rb @@ -4,7 +4,7 @@ describe 'between two relations' do before do @relation1 = TableRelation.new(:foo) @relation2 = TableRelation.new(:bar) - @predicate = EqualityPredicate.new(@relation1[:a], @relation2[:b]) + @predicate = EqualityPredicate.new(@relation1[:id], @relation2[:id]) end describe '==' do @@ -20,9 +20,9 @@ describe 'between two relations' do describe '#to_sql' do before do - @relation1 = @relation1.select(@relation1[:c] == @relation2[:d]) + @relation1 = @relation1.select(@relation1[:id] == @relation2[:foo_id]) class ConcreteJoinRelation < JoinRelation - def join_name + def join_type :inner_join end end @@ -30,19 +30,25 @@ describe 'between two relations' do it 'manufactures sql joining the two tables on the predicate, merging the selects' do ConcreteJoinRelation.new(@relation1, @relation2, @predicate).to_sql.to_s.should == SelectBuilder.new do - select { all } + select do + column :foo, :name + column :foo, :id + column :bar, :name + column :bar, :foo_id + column :bar, :id + end from :foo do inner_join :bar do equals do - column :foo, :a - column :bar, :b + column :foo, :id + column :bar, :id end end end where do equals do - column :foo, :c - column :bar, :d + column :foo, :id + column :bar, :foo_id end end end.to_s diff --git a/spec/relations/order_relation_spec.rb b/spec/relations/order_relation_spec.rb index 8050aa981c..d0654bd8da 100644 --- a/spec/relations/order_relation_spec.rb +++ b/spec/relations/order_relation_spec.rb @@ -4,8 +4,8 @@ describe OrderRelation do before do @relation1 = TableRelation.new(:foo) @relation2 = TableRelation.new(:bar) - @attribute1 = @relation1[:foo] - @attribute2 = @relation2[:bar] + @attribute1 = @relation1[:id] + @attribute2 = @relation2[:id] end describe '==' do @@ -18,13 +18,16 @@ describe OrderRelation do describe '#to_sql' do it "manufactures sql with an order clause" do - OrderRelation.new(@relation1, @attribute1).to_sql.should == SelectBuilder.new do - select { all } + OrderRelation.new(@relation1, @attribute1).to_sql.to_s.should == SelectBuilder.new do + select do + column :foo, :name + column :foo, :id + end from :foo order_by do - column :foo, :foo + column :foo, :id end - end + end.to_s end end diff --git a/spec/relations/projection_relation_spec.rb b/spec/relations/projection_relation_spec.rb index f17f57df7b..47386f966d 100644 --- a/spec/relations/projection_relation_spec.rb +++ b/spec/relations/projection_relation_spec.rb @@ -4,8 +4,8 @@ describe ProjectionRelation do before do @relation1 = TableRelation.new(:foo) @relation2 = TableRelation.new(:bar) - @attribute1 = @relation1[:foo] - @attribute2 = @relation2[:bar] + @attribute1 = @relation1[:id] + @attribute2 = @relation2[:id] end describe '==' do @@ -18,12 +18,12 @@ describe ProjectionRelation do describe '#to_sql' do it "manufactures sql with a limited select clause" do - ProjectionRelation.new(@relation1, @attribute1).to_sql.should == SelectBuilder.new do + ProjectionRelation.new(@relation1, @attribute1).to_sql.to_s.should == SelectBuilder.new do select do - column :foo, :foo + column :foo, :id end from :foo - end + end.to_s end end end
\ No newline at end of file diff --git a/spec/relations/range_relation_spec.rb b/spec/relations/range_relation_spec.rb index e6caa32e80..ea3901e3fd 100644 --- a/spec/relations/range_relation_spec.rb +++ b/spec/relations/range_relation_spec.rb @@ -21,7 +21,10 @@ describe RangeRelation do range_size = @range2.last - @range2.first + 1 range_start = @range2.first RangeRelation.new(@relation1, @range2).to_sql.to_s.should == SelectBuilder.new do - select { all } + select do + column :foo, :name + column :foo, :id + end from :foo limit range_size offset range_start diff --git a/spec/relations/relation_spec.rb b/spec/relations/relation_spec.rb index 6c2c2b8611..db4b6b8775 100644 --- a/spec/relations/relation_spec.rb +++ b/spec/relations/relation_spec.rb @@ -30,10 +30,6 @@ describe Relation do it "manufactures a range relation when given a range" do @relation1[1..2].should == RangeRelation.new(@relation1, 1..2) end - - it "raises an error if the named attribute is not part of the relation" do - pending - end end describe Relation, '#include?' do @@ -43,10 +39,6 @@ describe Relation do end describe Relation, '#project' do - it "only allows projecting attributes in the relation" do - pending - end - it "collapses identical projections" do pending end diff --git a/spec/relations/selection_relation_spec.rb b/spec/relations/selection_relation_spec.rb index ceb771b46d..1a7f9e6659 100644 --- a/spec/relations/selection_relation_spec.rb +++ b/spec/relations/selection_relation_spec.rb @@ -28,8 +28,11 @@ describe SelectionRelation do describe '#to_sql' do it "manufactures sql with where clause conditions" do - SelectionRelation.new(@relation1, @predicate1).to_sql.should == SelectBuilder.new do - select { all } + SelectionRelation.new(@relation1, @predicate1).to_sql.to_s.should == SelectBuilder.new do + select do + column :foo, :name + column :foo, :id + end from :foo where do equals do @@ -37,7 +40,7 @@ describe SelectionRelation do column :bar, :foo_id end end - end + end.to_s end end end
\ No newline at end of file diff --git a/spec/relations/table_relation_spec.rb b/spec/relations/table_relation_spec.rb index 7a820782df..8cd31a9ac8 100644 --- a/spec/relations/table_relation_spec.rb +++ b/spec/relations/table_relation_spec.rb @@ -3,7 +3,10 @@ require File.join(File.dirname(__FILE__), '..', 'spec_helper') describe TableRelation, '#to_sql' do it "returns a simple SELECT query" do TableRelation.new(:users).to_sql.should == SelectBuilder.new do |s| - select { all } + select do + column :users, :name + column :users, :id + end from :users end end diff --git a/spec/spec_helper.rb b/spec/spec_helper.rb index a764fff03e..c53277b8e3 100644 --- a/spec/spec_helper.rb +++ b/spec/spec_helper.rb @@ -3,6 +3,17 @@ require 'spec' require File.join(File.dirname(__FILE__), '..', 'lib', 'sql_algebra') require File.join(File.dirname(__FILE__), 'spec_helpers', 'be_like') +ActiveRecord::Base.configurations = { + 'sql_algebra_test' => { + :adapter => 'mysql', + :username => 'root', + :password => 'password', + :encoding => 'utf8', + :database => 'sql_algebra_test', + }, +} +ActiveRecord::Base.establish_connection 'sql_algebra_test' + Spec::Runner.configure do |config| config.include(BeLikeMatcher) end
\ No newline at end of file |