| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Feature`.`id`, `Feature`.`feature_category_id`, `Feature`.`title`, `Feature`.`body`, `Feature`.`body2`, `Feature`.`explain_title`, `Feature`.`movie_url`, `Feature`.`movie_title`, `Feature`.`movie_body`, `Feature`.`sub_title`, `Feature`.`sub1_body`, `Feature`.`sub2_body`, `Feature`.`sub_title_middle`, `Feature`.`sub3_body`, `Feature`.`sub4_body`, `Feature`.`sub_title_bottom`, `Feature`.`sub5_body`, `Feature`.`sub6_body`, `Feature`.`video1_title`, `Feature`.`video1_url`, `Feature`.`video2_title`, `Feature`.`video2_url`, `Feature`.`video3_title`, `Feature`.`video3_url`, `Feature`.`video4_title`, `Feature`.`video4_url`, `Feature`.`video5_title`, `Feature`.`video5_url`, `Feature`.`active`, `Feature`.`is_top`, `Feature`.`created`, `Feature`.`updated` FROM `user5014_db007`.`features` AS `Feature` WHERE `Feature`.`id` = 2 AND `Feature`.`active` = '1' ORDER BY `Feature`.`created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Item`.`id`, `Item`.`name`, `FeaturesItem`.`id`, `FeaturesItem`.`feature_id`, `FeaturesItem`.`item_id` FROM `user5014_db007`.`items` AS `Item` JOIN `user5014_db007`.`features_items` AS `FeaturesItem` ON (`FeaturesItem`.`feature_id` = 2 AND `FeaturesItem`.`item_id` = `Item`.`id`) ORDER BY `Item`.`id` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `user5014_db007`.`attachments` AS `Attachment` WHERE `model` = 'Feature' AND model_id = (2) | 6 | 6 | 3 | maybe slow |
| SELECT `Item`.`id`, `Item`.`name`, `Item`.`copy` FROM `user5014_db007`.`items` AS `Item` WHERE `Item`.`id` IS NULL AND `Item`.`active` = '1' ORDER BY `Item`.`parent_category_id` ASC, `Item`.`category_id` ASC, `Item`.`position` ASC | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `user5014_db007`.`footer_banner` AS `FooterBanner` WHERE `FooterBanner`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `FooterBanner`.`id`, `FooterBanner`.`banner1_image_url`, `FooterBanner`.`banner1_alt_name`, `FooterBanner`.`banner1_link_url`, `FooterBanner`.`banner1_outer_link_flg`, `FooterBanner`.`banner1_active_flg`, `FooterBanner`.`banner2_image_url`, `FooterBanner`.`banner2_alt_name`, `FooterBanner`.`banner2_link_url`, `FooterBanner`.`banner2_outer_link_flg`, `FooterBanner`.`banner2_active_flg`, `FooterBanner`.`banner3_image_url`, `FooterBanner`.`banner3_alt_name`, `FooterBanner`.`banner3_link_url`, `FooterBanner`.`banner3_outer_link_flg`, `FooterBanner`.`banner3_active_flg`, `FooterBanner`.`banner4_image_url`, `FooterBanner`.`banner4_alt_name`, `FooterBanner`.`banner4_link_url`, `FooterBanner`.`banner4_outer_link_flg`, `FooterBanner`.`banner4_active_flg`, `FooterBanner`.`banner5_image_url`, `FooterBanner`.`banner5_alt_name`, `FooterBanner`.`banner5_link_url`, `FooterBanner`.`banner5_outer_link_flg`, `FooterBanner`.`banner5_active_flg` FROM `user5014_db007`.`footer_banner` AS `FooterBanner` WHERE `FooterBanner`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `user5014_db007`.`attachments` AS `Attachment` WHERE `model` = 'FooterBanner' AND model_id = (1) | 5 | 5 | 3 | maybe slow |
