| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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 `Pickup`.`active` = '1' ORDER BY `Pickup`.`created` DESC LIMIT 5, 5 | 5 | 5 | 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` = 'Pickup' AND `model_id` IN (9, 8, 7, 5, 4) | 8 | 8 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `user5014_db007`.`pickups` AS `Pickup` WHERE `Pickup`.`active` = '1' | 1 | 1 | 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 | 2 | maybe slow |
