| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
| SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
| SELECT `Report`.`id`, `Report`.`title`, `Report`.`summary`, `Report`.`url`, `Report`.`seitekiurl`, `Report`.`content`, `Report`.`item_code1`, `Report`.`item_code2`, `Report`.`item_code3`, `Report`.`item_id1`, `Report`.`item_id2`, `Report`.`item_id3`, `Report`.`access`, `Report`.`created`, `Report`.`modified` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 888 LIMIT 1 | 1 | 1 | 0 | |
| BEGIN | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 888 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 888 | 1 | 1 | 0 | |
| UPDATE `witinc_pqnavi_test`.`md_reports` SET `access` = 4642, `modified` = '2025-08-06 22:54:39' WHERE `witinc_pqnavi_test`.`md_reports`.`id` = '888' | 1 | 1 | 1 | |
| COMMIT | 1 | 1 | 1 | |
| SELECT `Report`.`id`, `Report`.`title`, `Report`.`summary`, `Report`.`url`, `Report`.`seitekiurl`, `Report`.`content`, `Report`.`item_code1`, `Report`.`item_code2`, `Report`.`item_code3`, `Report`.`item_id1`, `Report`.`item_id2`, `Report`.`item_id3`, `Report`.`access`, `Report`.`created`, `Report`.`modified` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`created` < '2015-01-07 10:57:44' ORDER BY `Report`.`created` DESC LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Report`.`id`, `Report`.`title`, `Report`.`summary`, `Report`.`url`, `Report`.`seitekiurl`, `Report`.`content`, `Report`.`item_code1`, `Report`.`item_code2`, `Report`.`item_code3`, `Report`.`item_id1`, `Report`.`item_id2`, `Report`.`item_id3`, `Report`.`access`, `Report`.`created`, `Report`.`modified` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`created` >= '2015-01-06 14:28:29' AND `Report`.`created` != '2015-01-07 10:57:44' ORDER BY `Report`.`created` ASC LIMIT 2 | 2 | 2 | 5 | maybe slow |
| SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_code` = 'TR-0125-030' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 32 | maybe slow |
| SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (44691) | 1 | 1 | 15 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 44691 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 44691) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0125-030'))))) OR (((`item_id2` = 44691) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0125-030'))))) OR (((`item_id3` = 44691) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0125-030')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_code` = 'TR-0469-006' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 24 | maybe slow |
| SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (35313) | 2 | 2 | 15 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 35313 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35313) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0469-006'))))) OR (((`item_id2` = 35313) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0469-006'))))) OR (((`item_id3` = 35313) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0469-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_code` = 'TR-0578-006' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 20 | maybe slow |
| SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (36308) | 2 | 2 | 15 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 36308 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36308) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0578-006'))))) OR (((`item_id2` = 36308) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0578-006'))))) OR (((`item_id3` = 36308) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0578-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
| SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 888 | 1 | 1 | 0 | |
| SELECT `ReportsReportcategory`.`report_id` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 7 | 148 | 148 | 1 | |
| SELECT `Report`.`id`, `Report`.`title` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (34, 38, 43, 45, 47, 66, 70, 80, 130, 244, 256, 342, 418, 460, 461, 493, 511, 516, 517, 522, 537, 538, 543, 562, 567, 568, 571, 589, 595, 613, 615, 619, 621, 639, 640, 643, 652, 655, 658, 668, 670, 671, 682, 688, 692, 698, 710, 719, 722, 731, 743, 749, 755, 763, 770, 775, 776, 781, 794, 806, 812, 824, 830, 851, 853, 854, 855, 873, 882, 884, 888, 894, 908, 924, 930, 950, 956, 957, 973, 982, 998, 1024, 1029, 1033, 1036, 1054, 1060, 1063, 1078, 1081, 1083, 1100, 1197, 1311, 1323, 1352, 1364, 1368, 1380, 1393, 1398, 1405, 1413, 1427, 1434, 1448, 1453, 1458, 1463, 1468, 1486, 1491, 1502, 1511, 1517, 1530, 1545, 1550, 1565, 1580, 1591, 1595, 1608, 1617, 1621, 1635, 1662, 1669, 1687, 1703, 1713, 1723, 1749, 1755, 1769, 1778, 1793, 1803, 1824, 1839, 1852, 1860, 1873, 1879, 1894, 1911, 1920, 1931) ORDER BY `Report`.`created` DESC, `Report`.`id` DESC LIMIT 7 | 7 | 7 | 2 | maybe slow |
1 duplicate queries run.
