| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Notification`.`id`, `Notification`.`title`, date_format(view_date, "%Y.%m.%d") AS view_date, `Notification`.`linktype_id`, `Notification`.`link_url` FROM `user5014_db007`.`notifications` AS `Notification` WHERE `active` = '1' ORDER BY `view_date` DESC, `created` DESC LIMIT 12 | 12 | 12 | 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` = 'Notification' AND `model_id` IN (34, 33, 32, 31, 30, 22, 29, 28, 27, 26, 25, 24) | 12 | 12 | 2 | maybe slow |
| SELECT `Pickup`.`id`, `Pickup`.`pickup_category_id`, `Pickup`.`title`, `Pickup`.`body`, `Pickup`.`sub1_body`, `Pickup`.`sub2_body`, `Pickup`.`sub3_body`, `Pickup`.`sub4_body`, `Pickup`.`sub5_body`, `Pickup`.`active`, `Pickup`.`is_top`, `Pickup`.`created`, `Pickup`.`updated` FROM `user5014_db007`.`pickups` AS `Pickup` WHERE `active` = '1' AND `is_top` = '1' ORDER BY `created` DESC 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` = 'Pickup' AND model_id = (14) | 1 | 1 | 2 | maybe slow |
| 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 `active` = '1' ORDER BY `created` DESC LIMIT 6 | 5 | 5 | 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` = 'Feature' AND `model_id` IN (10, 7, 6, 5, 2) | 31 | 31 | 2 | maybe slow |
| SELECT `Catalog`.`id`, `Catalog`.`title`, `Catalog`.`link_url`, `Catalog`.`catalogtype_id` FROM `user5014_db007`.`catalogs` AS `Catalog` WHERE `active` = '1' ORDER BY `position` ASC LIMIT 8 | 6 | 6 | 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` = 'Catalog' AND `model_id` IN (1, 2, 5, 3, 4, 12) | 6 | 6 | 2 | maybe slow |
| 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 | 2 | maybe slow |