Gallery — Clementines

Restaurant Life

Baked Goods
Drinks
Grilled Cheese
Holidays
Restaurant Life
Salads
Sandwiches

« Back Next »

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgent
  time1576425368
  timeout10
- PostTypes
  0
  PostType
  id1
  nameBlock
  styleblock
  use_category1
  category_nameMenu Group
  use_file0
  use_poster0
  use_tag0
  use_attribute0
  ecommerce0
  order_bysort_order
  order_dirASC
  order_category_bysort_order
  order_category_dirASC
  num_display100
  multi_upload0
  allow_comment0
  approve_comments0
  created2009-10-06 09:26:43
  1
  PostType
  id2
  nameNews
  stylenews
  use_category1
  category_nameCategory
  use_file0
  use_poster0
  use_tag0
  use_attribute0
  ecommerce0
  order_bydisplay_date
  order_dirDESC
  order_category_bysort_order
  order_category_dirASC
  num_display20
  multi_upload0
  allow_comment0
  approve_comments0
  created2012-09-13 00:00:00
  2
  PostType
  id3
  nameGallery
  stylegallery
  use_category1
  category_nameAlbums
  use_file1
  use_poster0
  use_tag0
  use_attribute0
  ecommerce0
  order_bysort_order
  order_dirASC
  order_category_bysort_order
  order_category_dirASC
  num_display40
  multi_upload1
  allow_comment0
  approve_comments0
  created2012-09-14 00:00:00
- PostTypeOptions
  1Block
  2News
  3Gallery
- PostCategories
  0
  PostCategory
  id1
  post_type_id2
  nameSpecials - Century City
  body(null)
  source_only0
  sort_order1
  passcode
  created2012-09-13 00:00:00
  1
  PostCategory
  id2
  post_type_id2
  nameNews - Century City
  body(null)
  source_only0
  sort_order2
  passcode
  created2012-09-13 00:00:00
  2
  PostCategory
  id3
  post_type_id1
  nameTop
  body(null)
  source_only0
  sort_order1
  passcode
  created2012-09-13 00:00:00
  3
  PostCategory
  id4
  post_type_id1
  nameMenus
  body(null)
  source_only0
  sort_order2
  passcode
  created2012-09-13 00:00:00
  4
  PostCategory
  id5
  post_type_id1
  nameCatering
  body(null)
  source_only0
  sort_order3
  passcode
  created2012-09-13 00:00:00
  5
  PostCategory
  id6
  post_type_id1
  nameHome
  body(null)
  source_only0
  sort_order4
  passcode
  created2012-09-13 00:00:00
  6
  PostCategory
  id7
  post_type_id3
  nameRestaurant Life
  body
  source_only0
  sort_order1
  passcode
  created2012-09-14 00:00:00
  7
  PostCategory
  id8
  post_type_id3
  nameSalads
  body
  source_only0
  sort_order2
  passcode
  created2012-09-14 00:00:00
  8
  PostCategory
  id10
  post_type_id3
  nameGrilled Cheese
  body(null)
  source_only0
  sort_order4
  passcode
  created2012-09-14 00:00:00
  9
  PostCategory
  id11
  post_type_id3
  nameHolidays
  body
  source_only0
  sort_order5
  passcode
  created2012-09-14 00:00:00
  10
  PostCategory
  id12
  post_type_id1
  nameBeverly Hills Menus
  body(null)
  source_only0
  sort_order5
  passcode
  created2012-09-13 00:00:00
  11
  PostCategory
  id13
  post_type_id2
  nameSpecials - Beverly Hills
  body(null)
  source_only0
  sort_order3
  passcode
  created2012-09-13 00:00:00
  12
  PostCategory
  id14
  post_type_id2
  nameNews - Beverly Hills
  body(null)
  source_only0
  sort_order4
  passcode
  created2012-09-13 00:00:00
  13
  PostCategory
  id15
  post_type_id1
  nameBeverly Hills Catering
  body
  source_only0
  sort_order6
  passcode
  created2013-01-25 16:27:41
  14
  PostCategory
  id16
  post_type_id3
  nameBaked Goods
  body
  source_only0
  sort_order7
  passcode
  created2013-08-23 12:16:24
  15
  PostCategory
  id17
  post_type_id3
  nameSandwiches
  body
  source_only0
  sort_order8
  passcode
  created2014-01-07 12:35:52
  16
  PostCategory
  id18
  post_type_id3
  nameDrinks
  body
  source_only0
  sort_order9
  passcode
  created2014-01-07 13:17:56
- Selected
  PostType
  id3
  nameGallery
  stylegallery
  use_category1
  category_nameAlbums
  use_file1
  use_poster0
  use_tag0
  use_attribute0
  ecommerce0
  order_bysort_order
  order_dirASC
  order_category_bysort_order
  order_category_dirASC
  num_display40
  multi_upload1
  allow_comment0
  approve_comments0
  created2012-09-14 00:00:00
  PostCategory
  id7
  post_type_id3
  nameRestaurant Life
  body
  source_only0
  sort_order1
  passcode
  created2012-09-14 00:00:00
====
Request
Request

Cake Params
- controllerposts
- actionview
- named(empty)
- pass
  0225
- plugin(null)
- form(empty)
- url
  urlposts/view/225
- isAjax(false)
- paging
  PostComment
  page0
  current0
  count0
  prevPage(false)
  nextPage(false)
  pageCount0
  defaults
  limit1000
  step1
  contain
  0User.display_name
  1User.id
  order
  PostComment.createdasc
  conditions
  PostComment.post_id = 225
  PostComment.publish = 1
  options
  page0
  limit1000
  contain
  0User.display_name
  1User.id
  order
  PostComment.createdasc
  conditions
  PostComment.post_id = 225
  PostComment.publish = 1
$_GET
- urlposts/view/225
Cookie
- 0(empty)
Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  plugin(null)
  actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `posts`	20	20	1	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
SHOW FULL COLUMNS FROM `users`	15	15	1	maybe slow
SHOW FULL COLUMNS FROM `user_files`	15	15	1	maybe slow
SHOW FULL COLUMNS FROM `groups`	2	2	1	maybe slow
SHOW FULL COLUMNS FROM `post_comments`	12	12	1	maybe slow
SHOW FULL COLUMNS FROM `post_types`	19	19	1	maybe slow
SHOW FULL COLUMNS FROM `post_categories`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `post_notifications`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `tags`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `models_tags`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `post_attributes`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `post_attribute_types`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `posts_post_attributes`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `posts_user_files`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `posts_revs`	21	21	1
SHOW FULL COLUMNS FROM `posts_users`	4	4	1	maybe slow
SELECT `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created` FROM `post_types` AS `PostType` WHERE 1 = 1	3	3	0
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE 1 = 1	17	17	0
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`poster_user_file_id`, `Post`.`slug`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`ip`, `Post`.`display_date`, `Post`.`tags`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`price`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`group_id`, `User`.`profile_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`created`, `UserFile`.`modified`, `PosterUserFile`.`id`, `PosterUserFile`.`user_id`, `PosterUserFile`.`title`, `PosterUserFile`.`description`, `PosterUserFile`.`type`, `PosterUserFile`.`size`, `PosterUserFile`.`file_ext`, `PosterUserFile`.`media_type`, `PosterUserFile`.`original_file_name`, `PosterUserFile`.`width`, `PosterUserFile`.`height`, `PosterUserFile`.`playtime_string`, `PosterUserFile`.`sort_order`, `PosterUserFile`.`created`, `PosterUserFile`.`modified`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) LEFT JOIN `user_files` AS `PosterUserFile` ON (`Post`.`poster_user_file_id` = `PosterUserFile`.`id`) LEFT JOIN `post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`id` = 225 AND `Post`.`publish` = 1 ORDER BY `Post`.`sort_order` asc LIMIT 1	1	1	2	maybe slow
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`group_id`, `User`.`profile_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified` FROM `users` AS `User` WHERE `User`.`id` = 5	1	1	0
SELECT `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created` FROM `post_types` AS `PostType` WHERE `PostType`.`id` = 3	1	1	0
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`created`, `UserFile`.`modified` FROM `user_files` AS `UserFile` WHERE `UserFile`.`id` = 45	1	1	0
SELECT `PosterUserFile`.`id`, `PosterUserFile`.`user_id`, `PosterUserFile`.`title`, `PosterUserFile`.`description`, `PosterUserFile`.`type`, `PosterUserFile`.`size`, `PosterUserFile`.`file_ext`, `PosterUserFile`.`media_type`, `PosterUserFile`.`original_file_name`, `PosterUserFile`.`width`, `PosterUserFile`.`height`, `PosterUserFile`.`playtime_string`, `PosterUserFile`.`sort_order`, `PosterUserFile`.`created`, `PosterUserFile`.`modified` FROM `user_files` AS `PosterUserFile` WHERE `PosterUserFile`.`id` = 0	0	0	0
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `PostCategory`.`id` = 7	1	1	0
SELECT `PostNotification`.`id`, `PostNotification`.`post_id`, `PostNotification`.`user_id` FROM `post_notifications` AS `PostNotification` WHERE `PostNotification`.`post_id` = (225)	0	0	0
SELECT `MoreUserFile`.`id`, `MoreUserFile`.`user_id`, `MoreUserFile`.`title`, `MoreUserFile`.`description`, `MoreUserFile`.`type`, `MoreUserFile`.`size`, `MoreUserFile`.`file_ext`, `MoreUserFile`.`media_type`, `MoreUserFile`.`original_file_name`, `MoreUserFile`.`width`, `MoreUserFile`.`height`, `MoreUserFile`.`playtime_string`, `MoreUserFile`.`sort_order`, `MoreUserFile`.`created`, `MoreUserFile`.`modified`, `PostsUserFile`.`id`, `PostsUserFile`.`post_id`, `PostsUserFile`.`user_file_id`, `PostsUserFile`.`created` FROM `user_files` AS `MoreUserFile` JOIN `posts_user_files` AS `PostsUserFile` ON (`PostsUserFile`.`post_id` = 225 AND `PostsUserFile`.`user_file_id` = `MoreUserFile`.`id`)	0	0	0
SELECT `PostAttribute`.`id`, `PostAttribute`.`post_attribute_type_id`, `PostAttribute`.`name`, `PostAttribute`.`created`, `PostsPostAttribute`.`id`, `PostsPostAttribute`.`post_id`, `PostsPostAttribute`.`post_attribute_id`, `PostsPostAttribute`.`user_file_id`, `PostsPostAttribute`.`sku`, `PostsPostAttribute`.`quantity`, `PostsPostAttribute`.`featured`, `PostsPostAttribute`.`sort_order`, `PostsPostAttribute`.`created` FROM `post_attributes` AS `PostAttribute` JOIN `posts_post_attributes` AS `PostsPostAttribute` ON (`PostsPostAttribute`.`post_id` = 225 AND `PostsPostAttribute`.`post_attribute_id` = `PostAttribute`.`id`) ORDER BY `post_attribute_type_id` ASC, `name` asc	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `post_comments` AS `PostComment` LEFT JOIN `users` AS `User` ON (`PostComment`.`user_id` = `User`.`id`) WHERE `PostComment`.`post_id` = 225 AND `PostComment`.`publish` = 1	1	1	0
SELECT `PostComment`.`id`, `PostComment`.`post_id`, `PostComment`.`user_id`, `PostComment`.`author`, `PostComment`.`email`, `PostComment`.`text`, `PostComment`.`publish`, `PostComment`.`subscribe`, `PostComment`.`score`, `PostComment`.`ip`, `PostComment`.`agent`, `PostComment`.`created`, `User`.`display_name`, `User`.`id` FROM `post_comments` AS `PostComment` LEFT JOIN `users` AS `User` ON (`PostComment`.`user_id` = `User`.`id`) WHERE `PostComment`.`post_id` = 225 AND `PostComment`.`publish` = 1 ORDER BY `PostComment`.`created` asc LIMIT 1000	0	0	0
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `PostCategory`.`post_type_id` = 3 ORDER BY `PostCategory`.`name` asc	7	7	0
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`poster_user_file_id`, `Post`.`slug`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`ip`, `Post`.`display_date`, `Post`.`tags`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`price`, `Post`.`created`, `Post`.`modified`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`created`, `UserFile`.`modified` FROM `posts` AS `Post` LEFT JOIN `user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) WHERE `Post`.`sort_order` < 24 AND `Post`.`publish` = 1 AND `Post`.`post_category_id` = 7 AND `Post`.`post_type_id` = 3 ORDER BY `Post`.`sort_order` desc LIMIT 1	1	1	8	maybe slow
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`poster_user_file_id`, `Post`.`slug`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`ip`, `Post`.`display_date`, `Post`.`tags`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`price`, `Post`.`created`, `Post`.`modified`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`created`, `UserFile`.`modified` FROM `posts` AS `Post` LEFT JOIN `user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) WHERE `Post`.`sort_order` > 24 AND `Post`.`publish` = 1 AND `Post`.`post_category_id` = 7 AND `Post`.`post_type_id` = 3 ORDER BY `Post`.`sort_order` asc LIMIT 1	1	1	3	maybe slow
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `id` = 7 LIMIT 1	1	1	0
SELECT `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created` FROM `post_types` AS `PostType` WHERE 1 = 1	3	3	0
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`poster_user_file_id`, `Post`.`slug`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`ip`, `Post`.`display_date`, `Post`.`tags`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`price`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`group_id`, `User`.`profile_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`created`, `UserFile`.`modified`, `PosterUserFile`.`id`, `PosterUserFile`.`user_id`, `PosterUserFile`.`title`, `PosterUserFile`.`description`, `PosterUserFile`.`type`, `PosterUserFile`.`size`, `PosterUserFile`.`file_ext`, `PosterUserFile`.`media_type`, `PosterUserFile`.`original_file_name`, `PosterUserFile`.`width`, `PosterUserFile`.`height`, `PosterUserFile`.`playtime_string`, `PosterUserFile`.`sort_order`, `PosterUserFile`.`created`, `PosterUserFile`.`modified`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) LEFT JOIN `user_files` AS `PosterUserFile` ON (`Post`.`poster_user_file_id` = `PosterUserFile`.`id`) LEFT JOIN `post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`post_type_id` = 1 AND `Post`.`publish` = 1	45	45	1
SELECT `PostComment`.`id`, `PostComment`.`post_id`, `PostComment`.`user_id`, `PostComment`.`author`, `PostComment`.`email`, `PostComment`.`text`, `PostComment`.`publish`, `PostComment`.`subscribe`, `PostComment`.`score`, `PostComment`.`ip`, `PostComment`.`agent`, `PostComment`.`created` FROM `post_comments` AS `PostComment` WHERE `PostComment`.`publish` = 1 AND `PostComment`.`post_id` IN (108, 109, 110, 111, 112, 115, 116, 117, 119, 120, 122, 123, 124, 125, 126, 127, 129, 130, 131, 134, 137, 140, 141, 152, 155, 157, 159, 163, 167, 241, 465, 466, 467, 468, 471, 472, 473, 475, 476, 547, 1585, 2268, 2597, 4291, 4422)	0	0	0
SELECT `PostNotification`.`id`, `PostNotification`.`post_id`, `PostNotification`.`user_id` FROM `post_notifications` AS `PostNotification` WHERE `PostNotification`.`post_id` IN (108, 109, 110, 111, 112, 115, 116, 117, 119, 120, 122, 123, 124, 125, 126, 127, 129, 130, 131, 134, 137, 140, 141, 152, 155, 157, 159, 163, 167, 241, 465, 466, 467, 468, 471, 472, 473, 475, 476, 547, 1585, 2268, 2597, 4291, 4422)	0	0	0
SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `ModelsTag`.`id`, `ModelsTag`.`tag_id`, `ModelsTag`.`model`, `ModelsTag`.`model_id`, `ModelsTag`.`model_row`, `ModelsTag`.`created` FROM `tags` AS `Tag` JOIN `models_tags` AS `ModelsTag` ON (`ModelsTag`.`model_id` IN (108, 109, 110, 111, 112, 115, 116, 117, 119, 120, 122, 123, 124, 125, 126, 127, 129, 130, 131, 134, 137, 140, 141, 152, 155, 157, 159, 163, 167, 241, 465, 466, 467, 468, 471, 472, 473, 475, 476, 547, 1585, 2268, 2597, 4291, 4422) AND `ModelsTag`.`tag_id` = `Tag`.`id`) WHERE `ModelsTag`.`model` = "post"	0	0	0
SELECT `MoreUserFile`.`id`, `MoreUserFile`.`user_id`, `MoreUserFile`.`title`, `MoreUserFile`.`description`, `MoreUserFile`.`type`, `MoreUserFile`.`size`, `MoreUserFile`.`file_ext`, `MoreUserFile`.`media_type`, `MoreUserFile`.`original_file_name`, `MoreUserFile`.`width`, `MoreUserFile`.`height`, `MoreUserFile`.`playtime_string`, `MoreUserFile`.`sort_order`, `MoreUserFile`.`created`, `MoreUserFile`.`modified`, `PostsUserFile`.`id`, `PostsUserFile`.`post_id`, `PostsUserFile`.`user_file_id`, `PostsUserFile`.`created` FROM `user_files` AS `MoreUserFile` JOIN `posts_user_files` AS `PostsUserFile` ON (`PostsUserFile`.`post_id` IN (108, 109, 110, 111, 112, 115, 116, 117, 119, 120, 122, 123, 124, 125, 126, 127, 129, 130, 131, 134, 137, 140, 141, 152, 155, 157, 159, 163, 167, 241, 465, 466, 467, 468, 471, 472, 473, 475, 476, 547, 1585, 2268, 2597, 4291, 4422) AND `PostsUserFile`.`user_file_id` = `MoreUserFile`.`id`)	0	0	0
SELECT `PostAttribute`.`id`, `PostAttribute`.`post_attribute_type_id`, `PostAttribute`.`name`, `PostAttribute`.`created`, `PostsPostAttribute`.`id`, `PostsPostAttribute`.`post_id`, `PostsPostAttribute`.`post_attribute_id`, `PostsPostAttribute`.`user_file_id`, `PostsPostAttribute`.`sku`, `PostsPostAttribute`.`quantity`, `PostsPostAttribute`.`featured`, `PostsPostAttribute`.`sort_order`, `PostsPostAttribute`.`created` FROM `post_attributes` AS `PostAttribute` JOIN `posts_post_attributes` AS `PostsPostAttribute` ON (`PostsPostAttribute`.`post_id` IN (108, 109, 110, 111, 112, 115, 116, 117, 119, 120, 122, 123, 124, 125, 126, 127, 129, 130, 131, 134, 137, 140, 141, 152, 155, 157, 159, 163, 167, 241, 465, 466, 467, 468, 471, 472, 473, 475, 476, 547, 1585, 2268, 2597, 4291, 4422) AND `PostsPostAttribute`.`post_attribute_id` = `PostAttribute`.`id`) ORDER BY `post_attribute_type_id` ASC, `name` asc	0	0	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 3 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	8	8	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 4 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	7	7	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 5 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	9	9	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 6 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	5	5	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 12 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	6	6	0
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`title` FROM `posts` AS `Post` WHERE `Post`.`post_category_id` = 15 AND `Post`.`publish` = 1 AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`sort_order` ASC	9	9	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 7.26 MB

Message	Memory use
Component intitailization	3.24 MB
Controller action start	3.36 MB
Controller render start	3.75 MB
View render complete	4.64 MB

Timers

Total Request Time: 444 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	202.94
Component initialization and startup	14.42
Controller action	95.01
Render Controller Action	25.75
» Rendering View	20.90
» » Rendering APP/views/posts/view_gallery.ctp	17.00
» » » Rendering APP/views/elements/custom_select.ctp	0.47
» » » Rendering APP/views/elements/media_players.ctp	0.66
» » » Rendering APP/views/elements/social_links.ctp	0.24
» » » Rendering APP/views/elements/edit_post.ctp	0.29
» » » Rendering APP/views/elements/comment_section.ctp	0.40
» » Rendering APP/views/layouts/clementine.ctp	3.38
» » » Rendering APP/views/elements/analytics.ctp	0.23
» » » Rendering APP/views/elements/css.ctp	0.54
» » » Rendering APP/views/elements/javascripts.ctp	0.26
» » » Rendering APP/views/elements/system_divs.ctp	0.30

====

Log

Logs

====
Variables
View Variables
- menu_groups
  1
  Top
  0
  Post
  id108
  slugabout
  titleCentury City Bakery Cafe, Catering, Takeout, Prepared Meals
  1
  Post
  id122
  slugcommunity
  titleOur Community
  2
  Post
  id123
  slugcontact_bh
  titleContact / Location
  3
  Post
  id124
  sluggiftcard
  titleGive a Gift Card
  4
  Post
  id125
  sluggifts
  titleGifts
  5
  Post
  id155
  slugpress
  titlePress
  6
  Post
  id241
  slugcontact
  titleContact / Location
  7
  Post
  id1585
  slugjobs
  titleJob Opportunities
  Menus
  0
  Post
  id131
  slugmenu_allday
  titleAll Day
  1
  Post
  id152
  slugmenu_breakfast
  titleBreakfast
  2
  Post
  id137
  slugmenu_gourmet
  titleHeat-at-Home
  3
  Post
  id130
  slugmenu_afternoontea
  titleAfternoon Tea
  4
  Post
  id134
  slugmenu_christmas
  titleChristmas 2019
  5
  Post
  id141
  slugmenu_holidaygifts
  titleHoliday Gifts
  6
  Post
  id140
  slugmenu_hanukkah
  titleHanukkah 2019
  Catering
  0
  Post
  id120
  slugcatering_seasonal
  titleSeasonal Salad & Sandwich Choices
  1
  Post
  id111
  slugcatering_breakfast
  titleBreakfast
  2
  Post
  id116
  slugcatering_lunch
  titleLunch & Dinner
  3
  Post
  id115
  slugcatering_horsdoeuvres
  titleHors d’Oeuvres
  4
  Post
  id119
  slugcatering_saladbowls
  titleCatering Salad Bowls
  5
  Post
  id109
  slugcatering_afternoontea
  titleAfternoon Tea
  6
  Post
  id112
  slugcatering_cakes
  titleCakes & Sweets
  7
  Post
  id110
  slugcatering_beverages
  titleBeverages & More
  8
  Post
  id117
  slugcatering_overview
  titleOverview
  Home
  0
  Post
  id126
  slughome_about
  titleAbout Us
  1
  Post
  id127
  slughome_catering
  titleCatering
  2
  Post
  id129
  slughome_subscribe
  titleSubscribe
  3
  Post
  id4291
  slughome_joinourteam
  titleJoin Our Team!
  4
  Post
  id4422
  slughome_holidays
  titleHolidays
  Beverly Hills Menus
  0
  Post
  id157
  slugmenu_bh_allday
  titleAll Day
  1
  Post
  id159
  slugmenu_bh_breakfast
  titleBreakfast
  2
  Post
  id163
  slugmenu_bh_gourmet
  titleHeat-at-Home
  3
  Post
  id167
  slugmenu_bh_holidaygifts
  titleHoliday Gifts
  4
  Post
  id547
  slugmenu_bh_beverages
  titleBeverages
  5
  Post
  id2597
  slugtacotuesday
  titleTaco Tuesday!
  Beverly Hills Catering
  0
  Post
  id473
  slugcatering_bh_overview
  titleOverview
  1
  Post
  id467
  slugcatering_bh_breakfast
  titleBreakfast
  2
  Post
  id471
  slugcatering_bh_horsdoeuvres
  titleHors d’Oeuvres
  3
  Post
  id472
  slugcatering_bh_lunch
  titleLunch & Dinner
  4
  Post
  id475
  slugcatering_bh_saladbowls
  titleCatering Salad Bowls
  5
  Post
  id465
  slugcatering_bh_afternoontea
  titleAfternoon Tea
  6
  Post
  id468
  slugcatering_bh_cakes
  titleCakes & Sweets
  7
  Post
  id466
  slugcatering_bh_beverages
  titleBeverages & More
  8
  Post
  id476
  slugcatering_bh_seasonal
  titleSeasonal Salad & Sandwich Choices
- sectionGallery
- last_cache(false)
- isiOS(false)
- serverSubdomainbeverlyhills
- serverDomainclementineonline.com
- comment_notify(false)
- title_for_layoutClementines
- post_category
  PostCategory
  id7
  post_type_id3
  nameRestaurant Life
  body
  source_only0
  sort_order1
  passcode
  created2012-09-14 00:00:00
- post_category_id7
- formTimeStamp1576389368
- nextPost
  Post
  id226
  user_id5
  post_type_id3
  post_category_id7
  user_file_id46
  poster_user_file_id0
  slug(null)
  titleClementine
  body
  allow_comment1
  publish1
  public1
  ip198.101.116.122
  display_date2012-09-20 00:00:00
  tags
  source_only0
  sort_order25
  price0.00
  created2012-09-20 11:20:23
  modified2014-01-07 12:27:00
  UserFile
  id46
  user_id1
  title(null)
  description(null)
  typeapplication/octet-stream
  size1966587
  file_extjpg
  media_typeimage
  original_file_name67.jpg
  width2000
  height1333
  playtime_string(null)
  sort_order0
  created2012-09-20 11:20:23
  modified2012-09-20 11:20:23
- prevPost
  Post
  id201
  user_id5
  post_type_id3
  post_category_id7
  user_file_id21
  poster_user_file_id0
  slug(null)
  titleChicken Pot Pie
  body<p>Wish you could smell this through the computer...</p>
  allow_comment1
  publish1
  public1
  ip98.154.15.58
  display_date2012-09-20 00:00:00
  tags
  source_only0
  sort_order16
  price0.00
  created2012-09-20 11:18:20
  modified2014-01-04 14:14:11
  UserFile
  id21
  user_id1
  title(null)
  description(null)
  typeapplication/octet-stream
  size1334081
  file_extjpg
  media_typeimage
  original_file_name41.jpg
  width1333
  height2000
  playtime_string(null)
  sort_order0
  created2012-09-20 11:18:20
  modified2012-09-20 11:18:20
- post_categories
  0
  PostCategory
  id16
  post_type_id3
  nameBaked Goods
  body
  source_only0
  sort_order7
  passcode
  created2013-08-23 12:16:24
  1
  PostCategory
  id18
  post_type_id3
  nameDrinks
  body
  source_only0
  sort_order9
  passcode
  created2014-01-07 13:17:56
  2
  PostCategory
  id10
  post_type_id3
  nameGrilled Cheese
  body(null)
  source_only0
  sort_order4
  passcode
  created2012-09-14 00:00:00
  3
  PostCategory
  id11
  post_type_id3
  nameHolidays
  body
  source_only0
  sort_order5
  passcode
  created2012-09-14 00:00:00
  4
  PostCategory
  id7
  post_type_id3
  nameRestaurant Life
  body
  source_only0
  sort_order1
  passcode
  created2012-09-14 00:00:00
  5
  PostCategory
  id8
  post_type_id3
  nameSalads
  body
  source_only0
  sort_order2
  passcode
  created2012-09-14 00:00:00
  6
  PostCategory
  id17
  post_type_id3
  nameSandwiches
  body
  source_only0
  sort_order8
  passcode
  created2014-01-07 12:35:52
- post_comments(empty)
- post
  Post
  id225
  user_id5
  post_type_id3
  post_category_id7
  user_file_id45
  poster_user_file_id0
  slug(null)
  titleClementines
  body
  allow_comment1
  publish1
  public1
  ip198.101.116.122
  display_date2012-09-20 00:00:00
  tags
  source_only0
  sort_order24
  price0.00
  created2012-09-20 11:20:19
  modified2014-01-07 12:27:16
  User
  id5
  usernameannie@clementineonline.com
  passwordf58032b04cd9859cdd68879b9db345649a59a239
  display_nameAnnie
  description
  user_file_id0
  group_id2
  profile_id(null)
  notify_comment1
  active1
  confirmed1
  confirmation_code(null)
  reset_code(null)
  created2012-09-19 18:23:45
  modified2012-09-19 18:23:45
  PostType
  id3
  nameGallery
  stylegallery
  use_category1
  category_nameAlbums
  use_file1
  use_poster0
  use_tag0
  use_attribute0
  ecommerce0
  order_bysort_order
  order_dirASC
  order_category_bysort_order
  order_category_dirASC
  num_display40
  multi_upload1
  allow_comment0
  approve_comments0
  created2012-09-14 00:00:00
  UserFile
  id45
  user_id1
  title(null)
  description(null)
  typeapplication/octet-stream
  size2396968
  file_extjpg
  media_typeimage
  original_file_name66.jpg
  width2000
  height1333
  playtime_string(null)
  sort_order0
  created2012-09-20 11:20:19
  modified2012-09-20 11:20:19
  PosterUserFile
  id(null)
  user_id(null)
  title(null)
  description(null)
  type(null)
  size(null)
  file_ext(null)
  media_type(null)
  original_file_name(null)
  width(null)
  height(null)
  playtime_string(null)
  sort_order(null)
  created(null)
  modified(null)
  PostCategory
  id7
  post_type_id3
  nameRestaurant Life
  body
  source_only0
  sort_order1
  passcode
  created2012-09-14 00:00:00
  PostNotification(empty)
  MoreUserFile(empty)
  PostAttribute(empty)
- $this->data
  User
  username(null)
  display_name(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0jqueryEngine
  1js
  2paginator
  3simpleGraph
  4htmlToolbar
  5toolbar
  6video
  7number
  8cycle
  9time
  10session
  11javascript
  12form
  13html
  14block
====

Gallery — Clementines

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables