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 `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%記念品%') OR (`Item`.`item_name` Like '%記念品%') OR (`Item`.`item_figure` Like '%記念品%') OR (`Item`.`item_color` Like '%記念品%') OR (`Item`.`item_materials` Like '%記念品%') OR (`Item`.`item_note` Like '%記念品%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 167 | 167 | 246 | maybe slow |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` 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`.`id` IN (35724, 35724, 35725, 35725, 35726, 35726, 45144, 45144, 54069, 64618, 64618, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 72448, 72448, 74445, 74445, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81109, 81109, 81109, 81150, 81150, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 84492, 84492, 84517, 84518, 86583, 86833, 86834, 86835, 86836, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88540, 91435, 91436, 91437, 91438, 91439, 91585, 92333, 92334, 92850, 93154, 93984, 94037, 94318, 94318, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 95120, 95338, 95339, 95417, 95418, 95419, 95420, 96570, 97378, 97605, 97606, 97623, 97624, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97665, 97666, 97667, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97716, 97716, 97717, 97717, 97718, 97718, 97838, 98492, 98492, 98493, 98493, 99039, 99040, 99085, 99615, 99679, 99762, 99763, 99764) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 45, 15 | 15 | 15 | 1 | maybe slow |
SELECT COUNT(*) AS `count` 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`.`id` IN (35724, 35724, 35725, 35725, 35726, 35726, 45144, 45144, 54069, 64618, 64618, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 72448, 72448, 74445, 74445, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81109, 81109, 81109, 81150, 81150, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 84492, 84492, 84517, 84518, 86583, 86833, 86834, 86835, 86836, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88540, 91435, 91436, 91437, 91438, 91439, 91585, 92333, 92334, 92850, 93154, 93984, 94037, 94318, 94318, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 95120, 95338, 95339, 95417, 95418, 95419, 95420, 96570, 97378, 97605, 97606, 97623, 97624, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97665, 97666, 97667, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97716, 97716, 97717, 97717, 97718, 97718, 97838, 98492, 98492, 98493, 98493, 99039, 99040, 99085, 99615, 99679, 99762, 99763, 99764) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97678) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-314445'))))) OR (((`item_id2` = 97678) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-314445'))))) OR (((`item_id3` = 97678) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-314445')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 97678 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97605) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-300646'))))) OR (((`item_id2` = 97605) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-300646'))))) OR (((`item_id3` = 97605) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-300646')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 97605 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97623) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-306747'))))) OR (((`item_id2` = 97623) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-306747'))))) OR (((`item_id3` = 97623) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-306747')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 97623 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97677) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-314346'))))) OR (((`item_id2` = 97677) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-314346'))))) OR (((`item_id3` = 97677) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-314346')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 97677 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65221) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1157-011'))))) OR (((`item_id2` = 65221) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1157-011'))))) OR (((`item_id3` = 65221) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1157-011')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 65221 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95420) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-301742'))))) OR (((`item_id2` = 95420) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-301742'))))) OR (((`item_id3` = 95420) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-301742')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 95420 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95419) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-301643'))))) OR (((`item_id2` = 95419) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-301643'))))) OR (((`item_id3` = 95419) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-301643')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 95419 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95418) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-301544'))))) OR (((`item_id2` = 95418) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-301544'))))) OR (((`item_id3` = 95418) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-301544')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 95418 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95417) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-302046'))))) OR (((`item_id2` = 95417) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-302046'))))) OR (((`item_id3` = 95417) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-302046')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 95417 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91435) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1209-050'))))) OR (((`item_id2` = 91435) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1209-050'))))) OR (((`item_id3` = 91435) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1209-050')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 91435 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94335) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-296642'))))) OR (((`item_id2` = 94335) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-296642'))))) OR (((`item_id3` = 94335) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-296642')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 94335 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94556) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-289941'))))) OR (((`item_id2` = 94556) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-289941'))))) OR (((`item_id3` = 94556) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-289941')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 94556 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95120) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2924977'))))) OR (((`item_id2` = 95120) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2924977'))))) OR (((`item_id3` = 95120) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2924977')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
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` = 95120 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93984) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2391930'))))) OR (((`item_id2` = 93984) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2391930'))))) OR (((`item_id3` = 93984) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2391930')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | 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` = 93984 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0068-044'))))) OR (((`item_id2` = 35726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0068-044'))))) OR (((`item_id3` = 35726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0068-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 35726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |