| 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` = 36 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 531 | 531 | 21 | |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 36 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 (6777, 6778, 6779, 34832, 34833, 34834, 34837, 34969, 34970, 34971, 35292, 35301, 35310, 35343, 35403, 35760, 35764, 35783, 35785, 35786, 35788, 36308, 38504, 44664, 44678, 44760, 44761, 44762, 44781, 45516, 45518, 45529, 45539, 54083, 54085, 54086, 57650, 57651, 57652, 57684, 57685, 57686, 57687, 57688, 58132, 58134, 58136, 58141, 58142, 58143, 58155, 58156, 58231, 58345, 58348, 58349, 58350, 58354, 58355, 64547, 64630, 64631, 64637, 64638, 64639, 64670, 64671, 64672, 65209, 65263, 65264, 65267, 65268, 65271, 65272, 65273, 65276, 65277, 65280, 65282, 65297, 65309, 65313, 65331, 65338, 65340, 65353, 65360, 65364, 73667, 73678, 73691, 73697, 73734, 73737, 73747, 73763, 73776, 73777, 73780, 73781, 73806, 73810, 73811, 73812, 73845, 73864, 73870, 74424, 74753, 74754, 74768, 74769, 74782, 77166, 77167, 77169, 77191, 77230, 77245, 77246, 77250, 77251, 77254, 77255, 77256, 77590, 77604, 77614, 77615, 77616, 77617, 77631, 77632, 77658, 77660, 77668, 77699, 77700, 77705, 77710, 77733, 77736, 77743, 80646, 80666, 80667, 80673, 80674, 80676, 80677, 80692, 80693, 80704, 80706, 80709, 80710, 80711, 80712, 80713, 80714, 80715, 80717, 80725, 80726, 80727, 80728, 80784, 80790, 80800, 80803, 80804, 81471, 81472, 81474, 81499, 81506, 81509, 81510, 81521, 81522, 81523, 81524, 81528, 81530, 81532, 81533, 81540, 81541, 81542, 81543, 81544, 81545, 81546, 81567, 81568, 81569, 81570, 81572, 81590, 81591, 81592, 81593, 81594, 81613, 81614, 81615, 81616, 81621, 81622, 81623, 81667, 83757, 83758, 83759, 83771, 83792, 83796, 83804, 83814, 83815, 83834, 83855, 83877, 83878, 83898, 83899, 84313, 84314, 84315, 84318, 84321, 84322, 84323, 84326, 84327, 84328, 84332, 84343, 84344, 84345, 84422, 84423, 84424, 84425, 84427, 84428, 84429, 84480, 84481, 84482, 84483, 84492, 84493, 84494, 84495, 84503, 84533, 84534, 84535, 84536, 84539, 84546, 84547, 84569, 84570, 84571, 84576, 84577, 84578, 84579, 84580, 84584, 84585, 84590, 84593, 84594, 84595, 84596, 84597, 84598, 84599, 84601, 84603, 84604, 84606, 84607, 85004, 85012, 85014, 85015, 85016, 85017, 85039, 85040, 85041, 85064, 85065, 85069, 85070, 85071, 85091, 85092, 85093, 85094, 85104, 85105, 85106, 85107, 85108, 85121, 85122, 85124, 85125, 85130, 85131, 85132, 85133, 85134, 85147, 85148, 85149, 85150, 85170, 85171, 85172, 85175, 85178, 85179, 85180, 85181, 85182, 85183, 85184, 85185, 85186, 85187, 85188, 85208, 85209, 85220, 85632, 85633, 85634, 85635, 85647, 85664, 85665, 85684, 85685, 85696, 85697, 85698, 85699, 85701, 85702, 85703, 85709, 85713, 85714, 85715, 85716, 85723, 85728, 85729, 87301, 87302, 87303, 87304, 87305, 87306, 87307, 87308, 87309, 87310, 87311, 87312, 87313, 87317, 87318, 87332, 87333, 87334, 87335, 87336, 87337, 87338, 87339, 87340, 87341, 87353, 87354, 87362, 87365, 87366, 87367, 87368, 87369, 87370, 87374, 87375, 87382, 87383, 87384, 87385, 87386, 87387, 87391, 87392, 87393, 87702, 87722, 87723, 87850, 87851, 87855, 87856, 87860, 87861, 87862, 87863, 87864, 87865, 87866, 87867, 87868, 87869, 87870, 87871, 87872, 87873, 87886, 87887, 87888, 87889, 87899, 87913, 87914, 87915, 87916, 87942, 87943, 87944, 87945, 88181, 88182, 88183, 88184, 88185, 88186, 88187, 88188, 88189, 88190, 88208, 88228, 88229, 88238, 88283, 90397, 90429, 90430, 90682, 90683, 90684, 90745, 90746, 90934, 90935, 90936, 90940, 90941, 90942, 90943, 90944, 90945, 90946, 90947, 90948, 90949, 91001, 91003, 91004, 91587, 91588, 91616, 91617, 91618, 91619, 91620, 91621, 91679, 91680, 91681, 91682, 91683, 91684, 91685, 91686, 91687, 91688, 91689, 91690, 91691, 91692, 91693, 91694, 91695, 91696, 91697, 91698, 91699, 91700, 91701, 91702, 91703, 91704, 91705, 91706, 91707, 91708, 91709, 91710, 94431, 94432, 94433, 94434, 94435, 94498, 94502, 94506) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 4 | 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, 81667, 85147, 77246, 87383, 84313, 87384, 84580, 84547, 85729, 74424, 87333, 34969, 84546, 94432, 87336, 73747, 85209) | 40 | 40 | 26 | 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 (6777, 6778, 6779, 34832, 34833, 34834, 34837, 34969, 34970, 34971, 35292, 35301, 35310, 35343, 35403, 35760, 35764, 35783, 35785, 35786, 35788, 36308, 38504, 44664, 44678, 44760, 44761, 44762, 44781, 45516, 45518, 45529, 45539, 54083, 54085, 54086, 57650, 57651, 57652, 57684, 57685, 57686, 57687, 57688, 58132, 58134, 58136, 58141, 58142, 58143, 58155, 58156, 58231, 58345, 58348, 58349, 58350, 58354, 58355, 64547, 64630, 64631, 64637, 64638, 64639, 64670, 64671, 64672, 65209, 65263, 65264, 65267, 65268, 65271, 65272, 65273, 65276, 65277, 65280, 65282, 65297, 65309, 65313, 65331, 65338, 65340, 65353, 65360, 65364, 73667, 73678, 73691, 73697, 73734, 73737, 73747, 73763, 73776, 73777, 73780, 73781, 73806, 73810, 73811, 73812, 73845, 73864, 73870, 74424, 74753, 74754, 74768, 74769, 74782, 77166, 77167, 77169, 77191, 77230, 77245, 77246, 77250, 77251, 77254, 77255, 77256, 77590, 77604, 77614, 77615, 77616, 77617, 77631, 77632, 77658, 77660, 77668, 77699, 77700, 77705, 77710, 77733, 77736, 77743, 80646, 80666, 80667, 80673, 80674, 80676, 80677, 80692, 80693, 80704, 80706, 80709, 80710, 80711, 80712, 80713, 80714, 80715, 80717, 80725, 80726, 80727, 80728, 80784, 80790, 80800, 80803, 80804, 81471, 81472, 81474, 81499, 81506, 81509, 81510, 81521, 81522, 81523, 81524, 81528, 81530, 81532, 81533, 81540, 81541, 81542, 81543, 81544, 81545, 81546, 81567, 81568, 81569, 81570, 81572, 81590, 81591, 81592, 81593, 81594, 81613, 81614, 81615, 81616, 81621, 81622, 81623, 81667, 83757, 83758, 83759, 83771, 83792, 83796, 83804, 83814, 83815, 83834, 83855, 83877, 83878, 83898, 83899, 84313, 84314, 84315, 84318, 84321, 84322, 84323, 84326, 84327, 84328, 84332, 84343, 84344, 84345, 84422, 84423, 84424, 84425, 84427, 84428, 84429, 84480, 84481, 84482, 84483, 84492, 84493, 84494, 84495, 84503, 84533, 84534, 84535, 84536, 84539, 84546, 84547, 84569, 84570, 84571, 84576, 84577, 84578, 84579, 84580, 84584, 84585, 84590, 84593, 84594, 84595, 84596, 84597, 84598, 84599, 84601, 84603, 84604, 84606, 84607, 85004, 85012, 85014, 85015, 85016, 85017, 85039, 85040, 85041, 85064, 85065, 85069, 85070, 85071, 85091, 85092, 85093, 85094, 85104, 85105, 85106, 85107, 85108, 85121, 85122, 85124, 85125, 85130, 85131, 85132, 85133, 85134, 85147, 85148, 85149, 85150, 85170, 85171, 85172, 85175, 85178, 85179, 85180, 85181, 85182, 85183, 85184, 85185, 85186, 85187, 85188, 85208, 85209, 85220, 85632, 85633, 85634, 85635, 85647, 85664, 85665, 85684, 85685, 85696, 85697, 85698, 85699, 85701, 85702, 85703, 85709, 85713, 85714, 85715, 85716, 85723, 85728, 85729, 87301, 87302, 87303, 87304, 87305, 87306, 87307, 87308, 87309, 87310, 87311, 87312, 87313, 87317, 87318, 87332, 87333, 87334, 87335, 87336, 87337, 87338, 87339, 87340, 87341, 87353, 87354, 87362, 87365, 87366, 87367, 87368, 87369, 87370, 87374, 87375, 87382, 87383, 87384, 87385, 87386, 87387, 87391, 87392, 87393, 87702, 87722, 87723, 87850, 87851, 87855, 87856, 87860, 87861, 87862, 87863, 87864, 87865, 87866, 87867, 87868, 87869, 87870, 87871, 87872, 87873, 87886, 87887, 87888, 87889, 87899, 87913, 87914, 87915, 87916, 87942, 87943, 87944, 87945, 88181, 88182, 88183, 88184, 88185, 88186, 88187, 88188, 88189, 88190, 88208, 88228, 88229, 88238, 88283, 90397, 90429, 90430, 90682, 90683, 90684, 90745, 90746, 90934, 90935, 90936, 90940, 90941, 90942, 90943, 90944, 90945, 90946, 90947, 90948, 90949, 91001, 91003, 91004, 91587, 91588, 91616, 91617, 91618, 91619, 91620, 91621, 91679, 91680, 91681, 91682, 91683, 91684, 91685, 91686, 91687, 91688, 91689, 91690, 91691, 91692, 91693, 91694, 91695, 91696, 91697, 91698, 91699, 91700, 91701, 91702, 91703, 91704, 91705, 91706, 91707, 91708, 91709, 91710, 94431, 94432, 94433, 94434, 94435, 94498, 94502, 94506) AND `item_rank` <> 3 | 1 | 1 | 4 | 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 | 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` = 91680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| 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 | 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` = 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 | 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` = 81667 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81667) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-219146'))))) OR (((`item_id2` = 81667) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-219146'))))) OR (((`item_id3` = 81667) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-219146')))))) 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` = 85147 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85147) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1063-006'))))) OR (((`item_id2` = 85147) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1063-006'))))) OR (((`item_id3` = 85147) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1063-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` = 77246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-002'))))) OR (((`item_id2` = 77246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-002'))))) OR (((`item_id3` = 77246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-002')))))) 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` = 87383 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-009'))))) OR (((`item_id2` = 87383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-009'))))) OR (((`item_id3` = 87383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 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` = 87384 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87384) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-044'))))) OR (((`item_id2` = 87384) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-044'))))) OR (((`item_id3` = 87384) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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 | 1 | |
| 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 | 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` = 84547 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1038-002'))))) OR (((`item_id2` = 84547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1038-002'))))) OR (((`item_id3` = 84547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1038-002')))))) 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` = 85729 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85729) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-259845'))))) OR (((`item_id2` = 85729) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-259845'))))) OR (((`item_id3` = 85729) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-259845')))))) 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` = 74424 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74424) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-042348FC'))))) OR (((`item_id2` = 74424) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-042348FC'))))) OR (((`item_id3` = 74424) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-042348FC')))))) 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` = 87333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1125-009'))))) OR (((`item_id2` = 87333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1125-009'))))) OR (((`item_id3` = 87333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1125-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` = 34969 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34969) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TM-0028-009'))))) OR (((`item_id2` = 34969) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TM-0028-009'))))) OR (((`item_id3` = 34969) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TM-0028-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` = 84546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84546) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1038-001'))))) OR (((`item_id2` = 84546) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1038-001'))))) OR (((`item_id3` = 84546) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1038-001')))))) 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` = 94432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1811-007'))))) OR (((`item_id2` = 94432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1811-007'))))) OR (((`item_id3` = 94432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1811-007')))))) 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` = 87336 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87336) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1125-006'))))) OR (((`item_id2` = 87336) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1125-006'))))) OR (((`item_id3` = 87336) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1125-006')))))) 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` = 73747 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73747) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1197-044'))))) OR (((`item_id2` = 73747) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1197-044'))))) OR (((`item_id3` = 73747) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1197-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` = 85209 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85209) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1588-009'))))) OR (((`item_id2` = 85209) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1588-009'))))) OR (((`item_id3` = 85209) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1588-009')))))) 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 | |
![ノベルティ：＜アウトレット売切廃盤＞ [コスメポーチ] ユーティリティスクエアポーチ（S）](/img/item/ThumbnailTR-1063-006.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [事務用品/オフィス用品] コンパクトブラシ＆ダストパン](/img/item/ThumbnailTS-1641-009.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [事務用品/オフィス用品] コンパクトブラシ＆ダストパン](/img/item/ThumbnailTS-1641-044.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [折り畳みバッグ] クシャッと 抗菌エコバッグ（M）](/img/item/Thumbnailh-259845.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [鏡] フロストスクエアミラー（M）](/img/item/ThumbnailTM-0028-009.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [マグカップ] 磁器マグストレート](/img/item/ThumbnailTS-1197-044.jpg)
