| 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` = 1 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 364 | 364 | 0 | |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 1 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 (34832, 34833, 34834, 34837, 34907, 34908, 34909, 35016, 35017, 35387, 35388, 35389, 36242, 36243, 36244, 36245, 36246, 57764, 57765, 58128, 58129, 58130, 58131, 58132, 58134, 58136, 58141, 58142, 58143, 65278, 65280, 65282, 65334, 65335, 68732, 73727, 73729, 73730, 73731, 75898, 77327, 77329, 77330, 77705, 80035, 81177, 81526, 81527, 81528, 81529, 81530, 81532, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81541, 81542, 81543, 81544, 81545, 81546, 81722, 81723, 83385, 83873, 83874, 83875, 83877, 83878, 84147, 84241, 84421, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84570, 84571, 84572, 84573, 84574, 84576, 84577, 84578, 84579, 84580, 84581, 84582, 84583, 84584, 84585, 84590, 84591, 84592, 84593, 84594, 84595, 84911, 85211, 85236, 87851, 87853, 87854, 87855, 87856, 87857, 87858, 87859, 87911, 87912, 87913, 87914, 87915, 87916, 88214, 88215, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90411, 90412, 90413, 90414, 90415, 90750, 90751, 90752, 90753, 90934, 90935, 90936, 90937, 90938, 90939, 90940, 90941, 90942, 90943, 90944, 90945, 90946, 90947, 90948, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91001, 91002, 91003, 91004, 91005, 91006, 91022, 91023, 91024, 91025, 91026, 91045, 91115, 91131, 91389, 91480, 91589, 91590, 91591, 91592, 91643, 91644, 91749, 91833, 91834, 91835, 91836, 91839, 91840, 91841, 91843, 91844, 91845, 91846, 91847, 94318, 94319, 94374, 94404, 94405, 94406, 94407, 94408, 94410, 94411, 94412, 94413, 94414, 94415, 94416, 94417, 94421, 94422, 94423, 94424, 94425, 94426, 94427, 94428, 94429, 94430, 94595, 94596, 94597, 94598, 94599, 94600, 94601, 94602, 94603, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94725, 94726, 94727, 94728, 94729, 94730, 94731, 94732, 94733, 94734, 94735, 94736, 94737, 94757, 94758, 94759, 94762, 94817, 94827, 94828, 94830, 95070, 95071, 95072, 95090, 95165, 95434, 95435, 95436, 95437, 95595, 95596, 95597, 95806, 95811, 96430, 96431, 96432, 96434, 96437, 97370, 97391, 97392, 97625, 97681, 97708, 97709, 97710, 97711, 97716, 97717, 97718, 97720, 97721, 97722, 97723, 97724, 97725, 97787, 97788, 97800, 97801, 97802, 97803, 97804, 97840, 97841, 97842, 97843, 97844, 98052, 98053, 98054, 98055, 98056, 98057, 98058, 98059, 98060, 98061, 98062, 98063, 98064, 98139, 98140, 98141, 98142, 98143, 98144, 98145, 98146, 98147, 98148, 98149, 98414, 98417, 98418, 98422, 98663, 98664, 98665, 98666, 98667, 98668, 98669, 98670, 99459, 99460, 99461, 99462, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99472, 99473, 99474, 99475) 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 (94599, 84580, 98422, 94374, 81526, 34909, 94318, 97370, 97803, 77330, 98418, 98417, 98142, 98414, 57765, 36242, 98143, 98141, 98140, 98139) | 28 | 28 | 20 | 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 (34832, 34833, 34834, 34837, 34907, 34908, 34909, 35016, 35017, 35387, 35388, 35389, 36242, 36243, 36244, 36245, 36246, 57764, 57765, 58128, 58129, 58130, 58131, 58132, 58134, 58136, 58141, 58142, 58143, 65278, 65280, 65282, 65334, 65335, 68732, 73727, 73729, 73730, 73731, 75898, 77327, 77329, 77330, 77705, 80035, 81177, 81526, 81527, 81528, 81529, 81530, 81532, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81541, 81542, 81543, 81544, 81545, 81546, 81722, 81723, 83385, 83873, 83874, 83875, 83877, 83878, 84147, 84241, 84421, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84570, 84571, 84572, 84573, 84574, 84576, 84577, 84578, 84579, 84580, 84581, 84582, 84583, 84584, 84585, 84590, 84591, 84592, 84593, 84594, 84595, 84911, 85211, 85236, 87851, 87853, 87854, 87855, 87856, 87857, 87858, 87859, 87911, 87912, 87913, 87914, 87915, 87916, 88214, 88215, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90411, 90412, 90413, 90414, 90415, 90750, 90751, 90752, 90753, 90934, 90935, 90936, 90937, 90938, 90939, 90940, 90941, 90942, 90943, 90944, 90945, 90946, 90947, 90948, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91001, 91002, 91003, 91004, 91005, 91006, 91022, 91023, 91024, 91025, 91026, 91045, 91115, 91131, 91389, 91480, 91589, 91590, 91591, 91592, 91643, 91644, 91749, 91833, 91834, 91835, 91836, 91839, 91840, 91841, 91843, 91844, 91845, 91846, 91847, 94318, 94319, 94374, 94404, 94405, 94406, 94407, 94408, 94410, 94411, 94412, 94413, 94414, 94415, 94416, 94417, 94421, 94422, 94423, 94424, 94425, 94426, 94427, 94428, 94429, 94430, 94595, 94596, 94597, 94598, 94599, 94600, 94601, 94602, 94603, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94725, 94726, 94727, 94728, 94729, 94730, 94731, 94732, 94733, 94734, 94735, 94736, 94737, 94757, 94758, 94759, 94762, 94817, 94827, 94828, 94830, 95070, 95071, 95072, 95090, 95165, 95434, 95435, 95436, 95437, 95595, 95596, 95597, 95806, 95811, 96430, 96431, 96432, 96434, 96437, 97370, 97391, 97392, 97625, 97681, 97708, 97709, 97710, 97711, 97716, 97717, 97718, 97720, 97721, 97722, 97723, 97724, 97725, 97787, 97788, 97800, 97801, 97802, 97803, 97804, 97840, 97841, 97842, 97843, 97844, 98052, 98053, 98054, 98055, 98056, 98057, 98058, 98059, 98060, 98061, 98062, 98063, 98064, 98139, 98140, 98141, 98142, 98143, 98144, 98145, 98146, 98147, 98148, 98149, 98414, 98417, 98418, 98422, 98663, 98664, 98665, 98666, 98667, 98668, 98669, 98670, 99459, 99460, 99461, 99462, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99472, 99473, 99474, 99475) 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` = 94599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1843-044'))))) OR (((`item_id2` = 94599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1843-044'))))) OR (((`item_id3` = 94599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1843-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` = 84580 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84580) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1023-009'))))) OR (((`item_id2` = 84580) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1023-009'))))) OR (((`item_id3` = 84580) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1023-009')))))) 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` = 98422 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98422) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36235'))))) OR (((`item_id2` = 98422) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36235'))))) OR (((`item_id3` = 98422) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36235')))))) 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` = 94374 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94374) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35430'))))) OR (((`item_id2` = 94374) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35430'))))) OR (((`item_id3` = 94374) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35430')))))) 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` = 81526 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81526) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0971-009'))))) OR (((`item_id2` = 81526) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0971-009'))))) OR (((`item_id3` = 81526) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0971-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` = 34909 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34909) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0547-009'))))) OR (((`item_id2` = 34909) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0547-009'))))) OR (((`item_id3` = 34909) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0547-009')))))) 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` = 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 | 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` = 97370 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97370) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374681'))))) OR (((`item_id2` = 97370) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374681'))))) OR (((`item_id3` = 97370) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374681')))))) 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` = 97803 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97803) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846391'))))) OR (((`item_id2` = 97803) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846391'))))) OR (((`item_id3` = 97803) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846391')))))) 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` = 77330 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77330) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-184147'))))) OR (((`item_id2` = 77330) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-184147'))))) OR (((`item_id3` = 77330) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-184147')))))) 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` = 98418 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98418) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36222'))))) OR (((`item_id2` = 98418) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36222'))))) OR (((`item_id3` = 98418) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36222')))))) 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` = 98417 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98417) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36229'))))) OR (((`item_id2` = 98417) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36229'))))) OR (((`item_id3` = 98417) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36229')))))) 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` = 98142 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98142) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36111'))))) OR (((`item_id2` = 98142) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36111'))))) OR (((`item_id3` = 98142) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36111')))))) 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` = 98414 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98414) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36228'))))) OR (((`item_id2` = 98414) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36228'))))) OR (((`item_id3` = 98414) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36228')))))) 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` = 57765 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57765) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0989-009'))))) OR (((`item_id2` = 57765) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0989-009'))))) OR (((`item_id3` = 57765) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0989-009')))))) 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` = 36242 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36242) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h346-075049'))))) OR (((`item_id2` = 36242) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h346-075049'))))) OR (((`item_id3` = 36242) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h346-075049')))))) 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` = 98143 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98143) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36129'))))) OR (((`item_id2` = 98143) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36129'))))) OR (((`item_id3` = 98143) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36129')))))) 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` = 98141 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98141) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36106'))))) OR (((`item_id2` = 98141) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36106'))))) OR (((`item_id3` = 98141) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36106')))))) 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` = 98140 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98140) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36113'))))) OR (((`item_id2` = 98140) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36113'))))) OR (((`item_id3` = 98140) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36113')))))) 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` = 98139 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98139) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36088'))))) OR (((`item_id2` = 98139) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36088'))))) OR (((`item_id3` = 98139) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36088')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
| 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 | |
![ノベルティ：[生活雑貨] USBカップウォーマー](/img/item/ThumbnailTS-1843-044.jpg)
![ノベルティ：[掃除用品]ふわふわ折りたたみモップ](/img/item/ThumbnailMT-35430.jpg)
![ノベルティ：[生活雑貨] 2WAYネックウォーマー](/img/item/ThumbnailTR-0547-009.jpg)
