| 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`.`id` = 5 AND `Pickup`.`active` = '1' ORDER BY `Pickup`.`created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Item`.`id`, `Item`.`name`, `ItemsPickup`.`id`, `ItemsPickup`.`item_id`, `ItemsPickup`.`pickup_id` FROM `user5014_db007`.`items` AS `Item` JOIN `user5014_db007`.`items_pickups` AS `ItemsPickup` ON (`ItemsPickup`.`pickup_id` = 5 AND `ItemsPickup`.`item_id` = `Item`.`id`) ORDER BY `Item`.`id` ASC | 3 | 3 | 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 = (5) | 5 | 5 | 3 | maybe slow |
| SELECT `Item`.`id`, `Item`.`name`, `Item`.`copy` FROM `user5014_db007`.`items` AS `Item` WHERE `Item`.`id` IN (162, 163, 306) AND `Item`.`active` = '1' ORDER BY `Item`.`parent_category_id` ASC, `Item`.`category_id` ASC, `Item`.`position` ASC | 3 | 3 | 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` = 'Item' AND `model_id` IN (162, 163, 306) | 9 | 9 | 3 | 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 |
