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 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` = 97627) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313844'))))) OR (((`item_id2` = 97627) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313844'))))) OR (((`item_id3` = 97627) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313844')))))) 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` = 97627 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97378) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2392250'))))) OR (((`item_id2` = 97378) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2392250'))))) OR (((`item_id3` = 97378) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2392250')))))) 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` = 97378 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94318) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-293641'))))) OR (((`item_id2` = 94318) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-293641'))))) OR (((`item_id3` = 94318) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-293641')))))) 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` = 94318 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98493) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TE-0011-044'))))) OR (((`item_id2` = 98493) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TE-0011-044'))))) OR (((`item_id3` = 98493) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TE-0011-044')))))) 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` = 98493 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98492) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TE-0011-009'))))) OR (((`item_id2` = 98492) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TE-0011-009'))))) OR (((`item_id3` = 98492) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TE-0011-009')))))) 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` = 98492 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54069) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-99045'))))) OR (((`item_id2` = 54069) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-99045'))))) OR (((`item_id3` = 54069) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-99045')))))) 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` = 54069 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95338) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1884-044'))))) OR (((`item_id2` = 95338) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1884-044'))))) OR (((`item_id3` = 95338) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1884-044')))))) 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` = 95338 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81150) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2265600'))))) OR (((`item_id2` = 81150) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2265600'))))) OR (((`item_id3` = 81150) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2265600')))))) 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` = 81150 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97676) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-314247'))))) OR (((`item_id2` = 97676) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-314247'))))) OR (((`item_id3` = 97676) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-314247')))))) 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` = 97676 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97838) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565440'))))) OR (((`item_id2` = 97838) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565440'))))) OR (((`item_id3` = 97838) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565440')))))) 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` = 97838 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 45144) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-092541'))))) OR (((`item_id2` = 45144) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-092541'))))) OR (((`item_id3` = 45144) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-092541')))))) 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` = 45144 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1520-008'))))) OR (((`item_id2` = 84517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1520-008'))))) OR (((`item_id3` = 84517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1520-008')))))) 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` = 84517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64618) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1102-044'))))) OR (((`item_id2` = 64618) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1102-044'))))) OR (((`item_id3` = 64618) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1102-044')))))) 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` = 64618 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97675) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-314148'))))) OR (((`item_id2` = 97675) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-314148'))))) OR (((`item_id3` = 97675) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-314148')))))) 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` = 97675 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97637) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-303340'))))) OR (((`item_id2` = 97637) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-303340'))))) OR (((`item_id3` = 97637) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-303340')))))) 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` = 97637 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 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 | |