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` = 733 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 733 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 733 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_reports` SET `access` = 4012, `modified` = '2025-06-25 08:27:10' WHERE `witinc_pqnavi_test`.`md_reports`.`id` = '733' | 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` < '2014-07-08 00:05:20' 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` >= '2014-07-07 00:01:31' AND `Report`.`created` != '2014-07-08 00:05:20' 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` = '14469S5' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 42 | 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` = (53461) | 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` = 53461 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 53461) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14469S5'))))) OR (((`item_id2` = 53461) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14469S5'))))) OR (((`item_id3` = 53461) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14469S5')))))) 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` = '14465S1' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 33 | 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` = (53433) | 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` = 53433 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 53433) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14465S1'))))) OR (((`item_id2` = 53433) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14465S1'))))) OR (((`item_id3` = 53433) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14465S1')))))) 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` = '14H239' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 33 | 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` = (57977) | 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` = 57977 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57977) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14H239'))))) OR (((`item_id2` = 57977) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14H239'))))) OR (((`item_id3` = 57977) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14H239')))))) 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` = 733 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`report_id` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 11 | 225 | 225 | 0 | |
SELECT `Report`.`id`, `Report`.`title` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (349, 351, 353, 354, 360, 362, 364, 370, 373, 376, 377, 383, 384, 388, 391, 394, 397, 401, 405, 410, 415, 424, 430, 434, 440, 446, 452, 458, 463, 468, 475, 480, 486, 492, 499, 504, 510, 515, 521, 529, 534, 540, 546, 553, 558, 564, 570, 576, 582, 588, 594, 600, 606, 612, 618, 624, 630, 636, 642, 648, 654, 660, 667, 673, 679, 685, 691, 697, 703, 709, 715, 721, 727, 733, 740, 748, 754, 760, 766, 772, 778, 784, 790, 796, 802, 808, 813, 819, 825, 831, 837, 843, 849, 856, 862, 868, 874, 880, 886, 892, 898, 904, 910, 916, 922, 928, 934, 940, 946, 952, 958, 964, 970, 977, 983, 988, 994, 1000, 1007, 1013, 1019, 1025, 1031, 1037, 1043, 1049, 1055, 1061, 1066, 1071, 1074, 1079, 1084, 1089, 1094, 1101, 1106, 1111, 1116, 1121, 1127, 1131, 1136, 1140, 1145, 1151, 1157, 1162, 1174, 1180, 1185, 1190, 1196, 1201, 1208, 1214, 1219, 1224, 1230, 1234, 1239, 1245, 1251, 1257, 1264, 1270, 1275, 1280, 1286, 1292, 1297, 1302, 1308, 1314, 1319, 1325, 1330, 1336, 1344, 1349, 1354, 1360, 1365, 1370, 1376, 1381, 1385, 1389, 1394, 1399, 1402, 1406, 1409, 1414, 1419, 1423, 1428, 1439, 1444, 1449, 1454, 1459, 1464, 1469, 1476, 1482, 1487, 1492, 1498, 1503, 1508, 1513, 1518, 1521, 1525, 1531, 1536, 1546, 1551, 1556, 1561, 1566, 1587, 1592, 1597) ORDER BY `Report`.`created` DESC, `Report`.`id` DESC LIMIT 7 | 7 | 7 | 1 | maybe slow |
1 duplicate queries run.