Gallery — Annie Miler

Restaurant Life

Baked Goods
Drinks
Grilled Cheese
Holidays
Restaurant Life
Salads
Sandwiches

« Back Next »

Annie got her passion for baking as a kid...

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgent
  time1576425281
  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
 0200
- plugin(null)
- form(empty)
- url
 urlposts/view/200
- 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 = 200
 PostComment.publish = 1
 options
 page0
 limit1000
 contain
 0User.display_name
 1User.id
 order
 PostComment.createdasc
 conditions
 PostComment.post_id = 200
 PostComment.publish = 1
$_GET
- urlposts/view/200
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` = 200 AND `Post`.`publish` = 1 ORDER BY `Post`.`sort_order` asc LIMIT 1	1	1	1
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` = 20	1	1	1
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` = (200)	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` = 200 AND `PostsUserFile`.`user_file_id` = `MoreUserFile`.`id`)	0	0	1	maybe slow
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` = 200 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` = 200 AND `PostComment`.`publish` = 1	1	1	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`, `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` = 200 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` < 15 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	3	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` > 15 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	1	maybe slow
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.68 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: 468 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	197.81
Component initialization and startup	13.56
Controller action	106.41
Render Controller Action	29.43
» Rendering View	24.25
» » Rendering APP/views/posts/view_gallery.ctp	20.22
» » » Rendering APP/views/elements/custom_select.ctp	0.75
» » » Rendering APP/views/elements/media_players.ctp	1.05
» » » Rendering APP/views/elements/social_links.ctp	0.37
» » » Rendering APP/views/elements/edit_post.ctp	0.43
» » » Rendering APP/views/elements/comment_section.ctp	0.66
» » Rendering APP/views/layouts/clementine.ctp	3.42
» » » Rendering APP/views/elements/analytics.ctp	0.24
» » » 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_layoutAnnie Miler
- post_category
 PostCategory
 id7
 post_type_id3
 nameRestaurant Life
 body
 source_only0
 sort_order1
 passcode
 created2012-09-14 00:00:00
- post_category_id7
- formTimeStamp1576389281
- nextPost
 Post
 id201
 user_id5
 post_type_id3
 post_category_id7
 user_file_id21
 poster_user_file_id0
 slug(null)
 titleChicken Pot Pie
 bodyWish you could smell this through the computer...
 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
- prevPost
 Post
 id199
 user_id5
 post_type_id3
 post_category_id7
 user_file_id19
 poster_user_file_id0
 slug(null)
 titleAnnie Miler
 bodyHi!
 allow_comment1
 publish1
 public1
 ip98.154.15.58
 display_date2012-09-20 00:00:00
 tags
 source_only0
 sort_order14
 price0.00
 created2012-09-20 11:18:12
 modified2014-01-04 14:10:36
 UserFile
 id19
 user_id1
 title(null)
 description(null)
 typeapplication/octet-stream
 size1502466
 file_extjpg
 media_typeimage
 original_file_name38.jpg
 width1333
 height2000
 playtime_string(null)
 sort_order0
 created2012-09-20 11:18:12
 modified2012-09-20 11:18:12
- 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
 id200
 user_id5
 post_type_id3
 post_category_id7
 user_file_id20
 poster_user_file_id0
 slug(null)
 titleAnnie Miler
 bodyAnnie got her passion for baking as a kid... 
 allow_comment1
 publish1
 public1
 ip98.154.15.58
 display_date2012-09-20 00:00:00
 tags
 source_only0
 sort_order15
 price0.00
 created2012-09-20 11:18:16
 modified2014-01-04 14:13:03
 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
 id20
 user_id1
 title(null)
 description(null)
 typeapplication/octet-stream
 size1835670
 file_extjpg
 media_typeimage
 original_file_name39.jpg
 width1333
 height2000
 playtime_string(null)
 sort_order0
 created2012-09-20 11:18:16
 modified2012-09-20 11:18:16
 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 — Annie Miler

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables