| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Item`.`id`, `Item`.`parent_category_id`, `Item`.`category_id`, `Item`.`name`, `Item`.`copy`, `Item`.`item_number`, `Item`.`capacity`, `Item`.`case_max_num`, `Item`.`legal_classification`, `Item`.`optional_title1`, `Item`.`optional_detail1`, `Item`.`optional_title2`, `Item`.`optional_detail2`, `Item`.`optional_title3`, `Item`.`optional_detail3`, `Item`.`optional_title4`, `Item`.`optional_detail4`, `Item`.`optional_title5`, `Item`.`optional_detail5`, `Item`.`optional_title6`, `Item`.`optional_detail6`, `Item`.`optional_title7`, `Item`.`optional_detail7`, `Item`.`optional_title8`, `Item`.`optional_detail8`, `Item`.`feature`, `Item`.`primary_use`, `Item`.`how_to_use`, `Item`.`sub_title`, `Item`.`sub1_body`, `Item`.`sub2_body`, `Item`.`sub3_body`, `Item`.`sub4_body`, `Item`.`sub5_body`, `Item`.`video_url`, `Item`.`video_title`, `Item`.`video_mark`, `Item`.`remarks`, `Item`.`catalog_url`, `Item`.`product_catalog_number`, `Item`.`sicatalog_url`, `Item`.`position`, `Item`.`active`, `Item`.`created`, `Item`.`updated`, `ParentCategory`.`id`, `ParentCategory`.`name`, `Category`.`id`, `Category`.`name` FROM `user5014_db007`.`items` AS `Item` LEFT JOIN `user5014_db007`.`categories` AS `ParentCategory` ON (`Item`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `user5014_db007`.`categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`id` = 165 AND `Item`.`active` = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Litem`.`id`, `Litem`.`name`, `ItemsItem`.`id`, `ItemsItem`.`litem_id`, `ItemsItem`.`ritem_id` FROM `user5014_db007`.`items` AS `Litem` JOIN `user5014_db007`.`items_items` AS `ItemsItem` ON (`ItemsItem`.`litem_id` = 165 AND `ItemsItem`.`ritem_id` = `Litem`.`id`) WHERE `Litem`.`id` != 165 ORDER BY `Litem`.`id` ASC | 0 | 0 | 1 | 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` = 165 AND `ItemsTag`.`tag_id` = `Tag`.`id`) ORDER BY `Tag`.`position` ASC | 2 | 2 | 2 | |
| 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 = (165) | 2 | 2 | 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 `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 `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 1 = 1 | 1 | 1 | 1 | |
| 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 |
| 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 |