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` = 2299 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 2299 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 2299 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_reports` SET `access` = 547, `modified` = '2025-06-23 22:22:48' WHERE `witinc_pqnavi_test`.`md_reports`.`id` = '2299' | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 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`.`created` < '2024-12-02 12:49:54' ORDER BY `Report`.`created` DESC LIMIT 1 | 1 | 1 | 4 | 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` >= '2024-11-19 16:21:11' AND `Report`.`created` != '2024-12-02 12:49:54' 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` = '24N101' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 81 | 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` = (98304) | 1 | 1 | 16 | 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` = 98304 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98304) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '24N101'))))) OR (((`item_id2` = 98304) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '24N101'))))) OR (((`item_id3` = 98304) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '24N101')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
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` = '24N040' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 61 | 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` = (98257) | 1 | 1 | 13 | 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` = 98257 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98257) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '24N040'))))) OR (((`item_id2` = 98257) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '24N040'))))) OR (((`item_id3` = 98257) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '24N040')))))) 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` = '24N053' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 62 | 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` = (98270) | 1 | 1 | 14 | 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` = 98270 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98270) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '24N053'))))) OR (((`item_id2` = 98270) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '24N053'))))) OR (((`item_id3` = 98270) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '24N053')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 2299 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`report_id` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 2 | 219 | 219 | 1 | |
SELECT `Report`.`id`, `Report`.`title` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (65, 133, 136, 137, 139, 174, 181, 190, 197, 206, 214, 223, 227, 229, 231, 232, 236, 238, 239, 242, 245, 249, 254, 257, 264, 265, 277, 282, 283, 287, 292, 296, 305, 313, 316, 317, 319, 324, 328, 329, 330, 333, 340, 343, 347, 357, 361, 368, 374, 380, 386, 390, 396, 422, 442, 448, 473, 489, 498, 519, 524, 535, 541, 544, 551, 556, 561, 574, 586, 622, 649, 675, 680, 704, 728, 738, 757, 785, 809, 839, 847, 848, 864, 897, 912, 936, 960, 985, 987, 1015, 1039, 1065, 1086, 1105, 1128, 1139, 1149, 1171, 1178, 1193, 1215, 1238, 1261, 1283, 1307, 1331, 1353, 1375, 1395, 1412, 1440, 1452, 1474, 1497, 1539, 1543, 1544, 1560, 1578, 1584, 1596, 1609, 1614, 1623, 1630, 1647, 1673, 1686, 1700, 1701, 1718, 1735, 1744, 1753, 1767, 1771, 1785, 1794, 1802, 1804, 1806, 1808, 1820, 1835, 1837, 1846, 1847, 1848, 1872, 1888, 1902, 1919, 1935, 1955, 1956, 1964, 1968, 1975, 1977, 1983, 1993, 2002, 2017, 2023, 2033, 2036, 2050, 2064, 2073, 2089, 2103, 2109, 2115, 2118, 2123, 2127, 2129, 2130, 2136, 2142, 2149, 2155, 2158, 2163, 2166, 2170, 2173, 2175, 2181, 2185, 2189, 2194, 2197, 2200, 2204, 2208, 2211, 2214, 2218, 2223, 2227, 2231, 2236, 2237, 2241, 2246, 2249, 2253, 2257, 2261, 2270, 2274, 2278, 2281, 2285, 2287, 2290, 2295, 2299) ORDER BY `Report`.`created` DESC, `Report`.`id` DESC LIMIT 7 | 7 | 7 | 1 | maybe slow |
1 duplicate queries run.