| 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 `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 `ItemsCategory`.`category_id` = 15 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 631 | 631 | 16 | |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 15 AND `Category`.`flg_hidden` = 0 LIMIT 1 | 1 | 1 | 0 | |
| 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 (6064, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35191, 35192, 35193, 35198, 35209, 35210, 35261, 35262, 35263, 35264, 35271, 35286, 35287, 35288, 35289, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35302, 35303, 35326, 35328, 36308, 44682, 44683, 44685, 44689, 44693, 44694, 44696, 44698, 44699, 44700, 44701, 44702, 44703, 44708, 44709, 45522, 54036, 57746, 58227, 58229, 58230, 64673, 64674, 64676, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65264, 65267, 65268, 65269, 65270, 65271, 65272, 65273, 65274, 65276, 65277, 65295, 65340, 65351, 65352, 65353, 65358, 65363, 65364, 65365, 65366, 65373, 65374, 73767, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73847, 73848, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74368, 74372, 74393, 74446, 74450, 77707, 77708, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77736, 77743, 80653, 80654, 80656, 80657, 80658, 80659, 80660, 80661, 80662, 80663, 80664, 80669, 80670, 80671, 80673, 80674, 80676, 80677, 80678, 80679, 80680, 80681, 80682, 80683, 80684, 80686, 80687, 80688, 81569, 81570, 81572, 81573, 81574, 81577, 81578, 81579, 81580, 81581, 81582, 81585, 81586, 81587, 81590, 81591, 81592, 81593, 81594, 81595, 81596, 81597, 81598, 81599, 81600, 81601, 81602, 81603, 81604, 81605, 81606, 81607, 81608, 81609, 81610, 81611, 81612, 83767, 83770, 83771, 83892, 83893, 84313, 84314, 84315, 84422, 84423, 84424, 84425, 84427, 84428, 84429, 84442, 84443, 84444, 84445, 85025, 85026, 85027, 85029, 85031, 85032, 85039, 85040, 85041, 85069, 85070, 85071, 85077, 85078, 85079, 85080, 85081, 85091, 85092, 85093, 85094, 85333, 85642, 85643, 85644, 85645, 87317, 87318, 87332, 87333, 87334, 87335, 87336, 87347, 87348, 87349, 87350, 87351, 87860, 87861, 87862, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 88239, 88241, 88243, 88245, 88246, 90376, 90697, 90698, 90700, 90701, 90767, 90768, 90769, 90770, 90771, 90774, 90775, 90776, 90777, 90778, 90783, 90784, 90785, 90786, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90828, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91493, 91494, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91679, 91680, 91681, 91682, 91683, 91684, 91685, 91686, 91687, 91688, 91689, 91691, 91692, 91693, 91694, 91705, 91706, 91707, 91859, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 94282, 94283, 94360, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94703, 94704, 94706, 94707, 94708, 94827, 95122, 95124, 95127, 95128, 95129, 95219, 95220, 95221, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95247, 95248, 95421, 95422, 95423, 95462, 95463, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95489, 95490, 95492, 95498, 95499, 95500, 95501, 95662, 95663, 95664, 95665, 95666, 95667, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95760, 95761, 95762, 97384, 97385, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97845, 97846, 97847, 97848, 97849, 97868, 97869, 97870, 97872, 97873, 97874, 97875, 97888, 97889, 97890, 97897, 97898, 97899, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 98173, 98436, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98629, 98630, 99511, 99512, 99513, 99514, 99515, 99516, 99517, 99518, 99519, 99520, 99521, 99522, 99523, 99524, 99525, 99526, 99527, 99528, 99529) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 3 | 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` IN (77736, 91680, 65353, 35170, 35169, 81609, 35166, 74333, 84313, 98594, 98593, 91878, 74334, 98604, 98603, 98602, 98617, 98601, 98616, 98600) | 24 | 24 | 18 | 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 (6064, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35191, 35192, 35193, 35198, 35209, 35210, 35261, 35262, 35263, 35264, 35271, 35286, 35287, 35288, 35289, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35302, 35303, 35326, 35328, 36308, 44682, 44683, 44685, 44689, 44693, 44694, 44696, 44698, 44699, 44700, 44701, 44702, 44703, 44708, 44709, 45522, 54036, 57746, 58227, 58229, 58230, 64673, 64674, 64676, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65264, 65267, 65268, 65269, 65270, 65271, 65272, 65273, 65274, 65276, 65277, 65295, 65340, 65351, 65352, 65353, 65358, 65363, 65364, 65365, 65366, 65373, 65374, 73767, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73847, 73848, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74368, 74372, 74393, 74446, 74450, 77707, 77708, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77736, 77743, 80653, 80654, 80656, 80657, 80658, 80659, 80660, 80661, 80662, 80663, 80664, 80669, 80670, 80671, 80673, 80674, 80676, 80677, 80678, 80679, 80680, 80681, 80682, 80683, 80684, 80686, 80687, 80688, 81569, 81570, 81572, 81573, 81574, 81577, 81578, 81579, 81580, 81581, 81582, 81585, 81586, 81587, 81590, 81591, 81592, 81593, 81594, 81595, 81596, 81597, 81598, 81599, 81600, 81601, 81602, 81603, 81604, 81605, 81606, 81607, 81608, 81609, 81610, 81611, 81612, 83767, 83770, 83771, 83892, 83893, 84313, 84314, 84315, 84422, 84423, 84424, 84425, 84427, 84428, 84429, 84442, 84443, 84444, 84445, 85025, 85026, 85027, 85029, 85031, 85032, 85039, 85040, 85041, 85069, 85070, 85071, 85077, 85078, 85079, 85080, 85081, 85091, 85092, 85093, 85094, 85333, 85642, 85643, 85644, 85645, 87317, 87318, 87332, 87333, 87334, 87335, 87336, 87347, 87348, 87349, 87350, 87351, 87860, 87861, 87862, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 88239, 88241, 88243, 88245, 88246, 90376, 90697, 90698, 90700, 90701, 90767, 90768, 90769, 90770, 90771, 90774, 90775, 90776, 90777, 90778, 90783, 90784, 90785, 90786, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90828, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91493, 91494, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91679, 91680, 91681, 91682, 91683, 91684, 91685, 91686, 91687, 91688, 91689, 91691, 91692, 91693, 91694, 91705, 91706, 91707, 91859, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 94282, 94283, 94360, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94703, 94704, 94706, 94707, 94708, 94827, 95122, 95124, 95127, 95128, 95129, 95219, 95220, 95221, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95247, 95248, 95421, 95422, 95423, 95462, 95463, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95489, 95490, 95492, 95498, 95499, 95500, 95501, 95662, 95663, 95664, 95665, 95666, 95667, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95760, 95761, 95762, 97384, 97385, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97845, 97846, 97847, 97848, 97849, 97868, 97869, 97870, 97872, 97873, 97874, 97875, 97888, 97889, 97890, 97897, 97898, 97899, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 98173, 98436, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98629, 98630, 99511, 99512, 99513, 99514, 99515, 99516, 99517, 99518, 99519, 99520, 99521, 99522, 99523, 99524, 99525, 99526, 99527, 99528, 99529) AND `item_rank` <> 3 | 1 | 1 | 2 | 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` = 77736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0890-043'))))) OR (((`item_id2` = 77736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0890-043'))))) OR (((`item_id3` = 77736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0890-043')))))) 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` = 91680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91680) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1233-028'))))) OR (((`item_id2` = 91680) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1233-028'))))) OR (((`item_id3` = 91680) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1233-028')))))) 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` = 65353 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65353) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0435-043'))))) OR (((`item_id2` = 65353) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0435-043'))))) OR (((`item_id3` = 65353) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0435-043')))))) 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` = 35170 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35170) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-009'))))) OR (((`item_id2` = 35170) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-009'))))) OR (((`item_id3` = 35170) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-009')))))) 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` = 35169 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35169) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-008'))))) OR (((`item_id2` = 35169) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-008'))))) OR (((`item_id3` = 35169) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-008')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 81609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0962-028'))))) OR (((`item_id2` = 81609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0962-028'))))) OR (((`item_id3` = 81609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0962-028')))))) 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` = 35166 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35166) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0102-008'))))) OR (((`item_id2` = 35166) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0102-008'))))) OR (((`item_id3` = 35166) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0102-008')))))) 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` = 74333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0733NB'))))) OR (((`item_id2` = 74333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0733NB'))))) OR (((`item_id3` = 74333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0733NB')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 2 | 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` = 84313 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84313) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-238444'))))) OR (((`item_id2` = 84313) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-238444'))))) OR (((`item_id3` = 84313) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-238444')))))) 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` = 98594 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98594) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-008'))))) OR (((`item_id2` = 98594) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-008'))))) OR (((`item_id3` = 98594) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98593 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98593) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-006'))))) OR (((`item_id2` = 98593) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-006'))))) OR (((`item_id3` = 98593) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-006')))))) 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` = 91878 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91878) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G6F'))))) OR (((`item_id2` = 91878) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G6F'))))) OR (((`item_id3` = 91878) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G6F')))))) 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` = 74334 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74334) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0733ND'))))) OR (((`item_id2` = 74334) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0733ND'))))) OR (((`item_id3` = 74334) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0733ND')))))) 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` = 98604 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98604) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-045'))))) OR (((`item_id2` = 98604) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-045'))))) OR (((`item_id3` = 98604) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-045')))))) 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` = 98603 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98603) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-034'))))) OR (((`item_id2` = 98603) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-034'))))) OR (((`item_id3` = 98603) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-034')))))) 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` = 98602 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98602) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-011'))))) OR (((`item_id2` = 98602) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-011'))))) OR (((`item_id3` = 98602) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-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` = 98617 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98617) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-034'))))) OR (((`item_id2` = 98617) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-034'))))) OR (((`item_id3` = 98617) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-034')))))) 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` = 98601 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98601) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-009'))))) OR (((`item_id2` = 98601) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-009'))))) OR (((`item_id3` = 98601) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-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` = 98616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-009'))))) OR (((`item_id2` = 98616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-009'))))) OR (((`item_id3` = 98616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-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` = 98600 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98600) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-008'))))) OR (((`item_id2` = 98600) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-008'))))) OR (((`item_id3` = 98600) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-008')))))) 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 | |
