| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `user5014_db007`.`categories` AS `Category` WHERE `parent_id` != 0 AND `id` = 17 ORDER BY `Category`.`parent_id` ASC, `Category`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `user5014_db007`.`categories` AS `Category` WHERE `Category`.`id` = 1 ORDER BY `Category`.`parent_id` ASC, `Category`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`body`, `Tag`.`position`, `Tag`.`created`, `Tag`.`updated` FROM `user5014_db007`.`tags` AS `Tag` WHERE 1 = 1 ORDER BY `Tag`.`position` ASC | 15 | 15 | 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` = 'Tag' AND `model_id` IN (3, 4, 5, 6, 7, 8, 9, 10, 11, 1, 2, 12, 13, 14, 16) | 15 | 15 | 3 | maybe slow |
| SELECT `Item`.`id`, `Item`.`name`, `Item`.`copy` FROM `user5014_db007`.`items` AS `Item` WHERE `Item`.`parent_category_id` = 1 AND `Item`.`category_id` = 17 AND `Item`.`active` = '1' ORDER BY `Item`.`position` ASC LIMIT 5 | 5 | 5 | 2 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`position`, `ItemsTag`.`id`, `ItemsTag`.`item_id`, `ItemsTag`.`tag_id` FROM `user5014_db007`.`tags` AS `Tag` JOIN `user5014_db007`.`items_tags` AS `ItemsTag` ON (`ItemsTag`.`item_id` IN (33, 165, 24, 25, 26) AND `ItemsTag`.`tag_id` = `Tag`.`id`) ORDER BY `Tag`.`position` ASC | 10 | 10 | 2 | 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` = 'Item' AND `model_id` IN (33, 165, 24, 25, 26) | 10 | 10 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `user5014_db007`.`items` AS `Item` WHERE `Item`.`parent_category_id` = 1 AND `Item`.`category_id` = 17 AND `Item`.`active` = '1' | 1 | 1 | 1 | |
| 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 |