| 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` = 32 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 441 | 441 | 0 | |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 32 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 (12965, 29179, 29192, 29196, 29241, 35651, 35652, 35665, 38504, 44781, 54029, 54030, 54069, 57706, 57707, 57708, 57709, 58324, 64686, 65329, 65331, 65337, 65338, 69456, 73557, 73734, 73737, 73747, 74787, 74788, 75767, 77025, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77213, 77214, 77215, 77216, 77319, 77631, 77632, 77634, 77635, 77636, 77637, 78053, 78054, 78084, 78085, 78417, 79023, 80742, 80743, 80744, 80745, 81146, 81150, 81234, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81507, 81508, 82792, 83787, 83788, 83789, 83975, 83976, 84130, 84245, 84484, 84485, 84486, 84487, 84488, 84489, 84490, 84491, 84492, 84493, 84494, 84495, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84504, 84505, 84906, 85275, 85276, 85277, 85704, 86110, 87783, 87784, 87785, 87786, 87895, 87896, 87897, 87898, 87899, 87900, 87901, 87902, 88141, 88142, 88143, 88144, 88216, 88217, 88218, 88278, 88279, 88280, 88847, 88853, 88861, 88862, 88863, 88864, 88884, 88885, 88886, 88887, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90460, 90469, 90713, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90746, 90754, 90755, 90756, 90757, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91051, 91052, 91053, 91114, 91327, 91328, 91386, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91654, 91655, 91656, 91657, 91658, 91659, 91745, 92333, 92334, 92336, 92341, 92342, 92355, 92356, 92357, 92358, 92359, 92360, 92361, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 92383, 93940, 93941, 93942, 93944, 93951, 93977, 93978, 94265, 94269, 94270, 94275, 94276, 94317, 94335, 94336, 94343, 94352, 94353, 94357, 94358, 94362, 94363, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94493, 94495, 94496, 94509, 94510, 94511, 94512, 94518, 94519, 94520, 94521, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94745, 94746, 94747, 94821, 94852, 94853, 94854, 94855, 94856, 95073, 95130, 95131, 95132, 95133, 95134, 95139, 95140, 95141, 95142, 95143, 95144, 95147, 95338, 95339, 95417, 95569, 95570, 95571, 95572, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95604, 95605, 95606, 95607, 95608, 95656, 95657, 95851, 95853, 95854, 95855, 95856, 95857, 95858, 96568, 96569, 96570, 96577, 96579, 96583, 96586, 96588, 97370, 97605, 97606, 97626, 97627, 97628, 97629, 98174, 98427, 98428, 98429, 98438, 98445, 98446, 98447, 98448, 98449, 98785, 98786, 98787, 98788, 98789, 98790, 98791, 98792, 98793, 98794, 98795, 98796, 98797, 98798, 98799, 98800, 98801, 98802, 98803, 98804, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99392, 99393, 99394, 99395, 99396, 99397) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 2 | 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 (95073, 90736, 95575, 94362, 90460, 94358, 94745, 91052, 91053, 91051, 95607, 79023, 84906, 12965, 95606, 98449, 97627, 83975, 78417, 97370) | 22 | 22 | 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 (12965, 29179, 29192, 29196, 29241, 35651, 35652, 35665, 38504, 44781, 54029, 54030, 54069, 57706, 57707, 57708, 57709, 58324, 64686, 65329, 65331, 65337, 65338, 69456, 73557, 73734, 73737, 73747, 74787, 74788, 75767, 77025, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77213, 77214, 77215, 77216, 77319, 77631, 77632, 77634, 77635, 77636, 77637, 78053, 78054, 78084, 78085, 78417, 79023, 80742, 80743, 80744, 80745, 81146, 81150, 81234, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81507, 81508, 82792, 83787, 83788, 83789, 83975, 83976, 84130, 84245, 84484, 84485, 84486, 84487, 84488, 84489, 84490, 84491, 84492, 84493, 84494, 84495, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84504, 84505, 84906, 85275, 85276, 85277, 85704, 86110, 87783, 87784, 87785, 87786, 87895, 87896, 87897, 87898, 87899, 87900, 87901, 87902, 88141, 88142, 88143, 88144, 88216, 88217, 88218, 88278, 88279, 88280, 88847, 88853, 88861, 88862, 88863, 88864, 88884, 88885, 88886, 88887, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90460, 90469, 90713, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90746, 90754, 90755, 90756, 90757, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91051, 91052, 91053, 91114, 91327, 91328, 91386, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91654, 91655, 91656, 91657, 91658, 91659, 91745, 92333, 92334, 92336, 92341, 92342, 92355, 92356, 92357, 92358, 92359, 92360, 92361, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 92383, 93940, 93941, 93942, 93944, 93951, 93977, 93978, 94265, 94269, 94270, 94275, 94276, 94317, 94335, 94336, 94343, 94352, 94353, 94357, 94358, 94362, 94363, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94493, 94495, 94496, 94509, 94510, 94511, 94512, 94518, 94519, 94520, 94521, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94745, 94746, 94747, 94821, 94852, 94853, 94854, 94855, 94856, 95073, 95130, 95131, 95132, 95133, 95134, 95139, 95140, 95141, 95142, 95143, 95144, 95147, 95338, 95339, 95417, 95569, 95570, 95571, 95572, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95604, 95605, 95606, 95607, 95608, 95656, 95657, 95851, 95853, 95854, 95855, 95856, 95857, 95858, 96568, 96569, 96570, 96577, 96579, 96583, 96586, 96588, 97370, 97605, 97606, 97626, 97627, 97628, 97629, 98174, 98427, 98428, 98429, 98438, 98445, 98446, 98447, 98448, 98449, 98785, 98786, 98787, 98788, 98789, 98790, 98791, 98792, 98793, 98794, 98795, 98796, 98797, 98798, 98799, 98800, 98801, 98802, 98803, 98804, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99392, 99393, 99394, 99395, 99396, 99397) AND `item_rank` <> 3 | 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` = 95073 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95073) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374071'))))) OR (((`item_id2` = 95073) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374071'))))) OR (((`item_id3` = 95073) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374071')))))) 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` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) 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` = 95575 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95575) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1883-044'))))) OR (((`item_id2` = 95575) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1883-044'))))) OR (((`item_id3` = 95575) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1883-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` = 94362 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35417'))))) OR (((`item_id2` = 94362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35417'))))) OR (((`item_id3` = 94362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35417')))))) 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` = 90460 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90460) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708721'))))) OR (((`item_id2` = 90460) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708721'))))) OR (((`item_id3` = 90460) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708721')))))) 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` = 94358 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94358) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35383SV'))))) OR (((`item_id2` = 94358) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35383SV'))))) OR (((`item_id3` = 94358) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35383SV')))))) 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` = 94745 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94745) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2373861'))))) OR (((`item_id2` = 94745) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2373861'))))) OR (((`item_id3` = 94745) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2373861')))))) 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` = 91052 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91052) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372731'))))) OR (((`item_id2` = 91052) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372731'))))) OR (((`item_id3` = 91052) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372731')))))) 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` = 91053 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91053) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372741'))))) OR (((`item_id2` = 91053) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372741'))))) OR (((`item_id3` = 91053) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372741')))))) 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` = 91051 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91051) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372721'))))) OR (((`item_id2` = 91051) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372721'))))) OR (((`item_id3` = 91051) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372721')))))) 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` = 95607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846261'))))) OR (((`item_id2` = 95607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846261'))))) OR (((`item_id3` = 95607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846261')))))) 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` = 79023 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79023) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G8'))))) OR (((`item_id2` = 79023) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G8'))))) OR (((`item_id3` = 79023) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G8')))))) 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` = 84906 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84906) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2711971'))))) OR (((`item_id2` = 84906) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2711971'))))) OR (((`item_id3` = 84906) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2711971')))))) 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` = 12965 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 12965) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206849'))))) OR (((`item_id2` = 12965) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206849'))))) OR (((`item_id3` = 12965) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206849')))))) 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` = 95606 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95606) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846271'))))) OR (((`item_id2` = 95606) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846271'))))) OR (((`item_id3` = 95606) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846271')))))) 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` = 98449 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98449) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375341'))))) OR (((`item_id2` = 98449) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375341'))))) OR (((`item_id3` = 98449) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375341')))))) 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` = 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` = 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 | 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` = 83975 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83975) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-226946'))))) OR (((`item_id2` = 83975) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-226946'))))) OR (((`item_id3` = 83975) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-226946')))))) 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` = 78417 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78417) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25260G10'))))) OR (((`item_id2` = 78417) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25260G10'))))) OR (((`item_id3` = 78417) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25260G10')))))) 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 | 0 | |
| 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 | 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 | |
![ノベルティ：[キャラクター] ディズニー・キャラクター 真空ステンレスタンブラーセット 300mL](/img/item/Thumbnail25076G08.jpg)
