Gallery — Clementine
Restaurant Life
- Baked Goods
- Drinks
- Grilled Cheese
- Holidays
- Restaurant Life
- Salads
- Sandwiches

Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
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` = 226 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` = 46 | 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` = (226) | 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` = 226 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` = 226 AND `PostsPostAttribute`.`post_attribute_id` = `PostAttribute`.`id`) ORDER BY `post_attribute_type_id` ASC, `name` asc | 0 | 0 | 0 | ||
SELECT COUNT(*) AS `count` FROM `post_comments` AS `PostComment` LEFT JOIN `users` AS `User` ON (`PostComment`.`user_id` = `User`.`id`) WHERE `PostComment`.`post_id` = 226 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` = 226 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` < 25 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` > 25 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 |
Peak Memory Use 7.09 MB
Message | Memory use |
---|---|
Component intitailization | 3.19 MB |
Controller action start | 3.35 MB |
Controller render start | 3.69 MB |
View render complete | 4.58 MB |
Total Request Time: 229 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 88.97 | |
Component initialization and startup | 10.91 | |
Controller action | 35.70 | |
Render Controller Action | 18.08 | |
» Rendering View | 16.69 | |
» » Rendering APP/views/posts/view_gallery.ctp | 12.93 | |
» » » Rendering APP/views/elements/custom_select.ctp | 0.47 | |
» » » Rendering APP/views/elements/media_players.ctp | 0.67 | |
» » » Rendering APP/views/elements/social_links.ctp | 0.24 | |
» » » Rendering APP/views/elements/edit_post.ctp | 0.28 | |
» » » Rendering APP/views/elements/comment_section.ctp | 0.40 | |
» » Rendering APP/views/layouts/clementine.ctp | 3.28 | |
» » » Rendering APP/views/elements/analytics.ctp | 0.25 | |
» » » Rendering APP/views/elements/css.ctp | 0.54 | |
» » » Rendering APP/views/elements/javascripts.ctp | 0.26 | |
» » » Rendering APP/views/elements/system_divs.ctp | 0.29 |