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` = 713 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 713 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` = 713 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_reports` SET `access` = 3741, `modified` = '2025-06-25 06:19:07' WHERE `witinc_pqnavi_test`.`md_reports`.`id` = '713' | 1 | 1 | 2 | maybe slow |
COMMIT | 1 | 1 | 2 | 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-06-14 19:56:03' ORDER BY `Report`.`created` DESC LIMIT 1 | 1 | 1 | 3 | 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-06-13 07:59:28' AND `Report`.`created` != '2014-06-14 19:56:03' ORDER BY `Report`.`created` ASC LIMIT 2 | 2 | 2 | 3 | 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` = '14H025' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 36 | 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` = (57800) | 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` = 57800 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57800) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14H025'))))) OR (((`item_id2` = 57800) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14H025'))))) OR (((`item_id3` = 57800) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14H025')))))) 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` = '14NK-154' 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` = (58096) | 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` = 58096 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 58096) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14NK-154'))))) OR (((`item_id2` = 58096) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14NK-154'))))) OR (((`item_id3` = 58096) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14NK-154')))))) 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` = '14H108C' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 37 | 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` = (57865) | 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` = 57865 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57865) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '14H108C'))))) OR (((`item_id2` = 57865) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '14H108C'))))) OR (((`item_id3` = 57865) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '14H108C')))))) 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` = 713 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`report_id` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 12 | 95 | 95 | 0 | |
SELECT `Report`.`id`, `Report`.`title` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (407, 408, 426, 428, 453, 454, 487, 488, 505, 506, 531, 532, 577, 578, 603, 604, 631, 633, 663, 664, 683, 686, 712, 713, 736, 737, 764, 767, 788, 791, 815, 817, 842, 845, 878, 879, 896, 903, 918, 920, 945, 948, 963, 968, 992, 996, 1021, 1023, 1047, 1048, 1073, 1076, 1091, 1098, 1115, 1120, 1138, 1141, 1159, 1164, 1176, 1181, 1199, 1202, 1222, 1227, 1260, 1273, 1291, 1315, 1343, 1371, 1386, 1403, 1445, 1462, 1481, 1506, 1537, 1552, 1563, 1588, 1605, 1618, 1636, 1653, 1684, 1696, 1708, 1727, 1737, 1757, 1776, 1800, 1815) ORDER BY `Report`.`created` DESC, `Report`.`id` DESC LIMIT 7 | 7 | 7 | 1 | maybe slow |
1 duplicate queries run.