| 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` = 40 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 191 | 191 | 22 | maybe slow |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 40 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 (3829, 6163, 6164, 6514, 6516, 35673, 35674, 35675, 35676, 38489, 44174, 44175, 54049, 54050, 54051, 54053, 54082, 64442, 64549, 64550, 73643, 73719, 73720, 74284, 74285, 74286, 74291, 74292, 74297, 74764, 74765, 74766, 74767, 74768, 74769, 77699, 77700, 80692, 80693, 84286, 85508, 87383, 87384, 87935, 89745, 89746, 89766, 91015, 91016, 91018, 91019, 91020, 91021, 91336, 91388, 91750, 93492, 93506, 93511, 93512, 93514, 93515, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93568, 93584, 93591, 93592, 93594, 93598, 93599, 93600, 93604, 93605, 93606, 93607, 93608, 93934, 93982, 94253, 94254, 94257, 94258, 95770, 96178, 96179, 96180, 96182, 96183, 96184, 96185, 96186, 96187, 96188, 96189, 96192, 96193, 96194, 96195, 96196, 96197, 96198, 96199, 96200, 96201, 96203, 96204, 96209, 96846, 96851, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96863, 96867, 96868, 96869, 96872, 96874, 96875, 96876, 96877, 96878, 96879, 96880, 96881, 96882, 96883, 97620, 97621, 97622, 97623, 97624, 97792, 98183, 98186, 98417, 98420, 98421, 98432, 98490, 98491, 98521, 98698, 98699, 98700, 98701, 98702, 98703, 98704, 98705, 98706, 98707, 98708, 99370, 99371, 99372, 99373, 99374, 99375, 99376, 99377, 99378, 99379, 99380, 99381, 99382, 99383) 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 (87935, 96197, 87383, 87384, 6516, 98421, 98491, 98521, 98490, 6514, 98420, 98186, 97792, 98417, 96876, 74291, 98432, 98183, 91336, 3829) | 27 | 27 | 23 | 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 (3829, 6163, 6164, 6514, 6516, 35673, 35674, 35675, 35676, 38489, 44174, 44175, 54049, 54050, 54051, 54053, 54082, 64442, 64549, 64550, 73643, 73719, 73720, 74284, 74285, 74286, 74291, 74292, 74297, 74764, 74765, 74766, 74767, 74768, 74769, 77699, 77700, 80692, 80693, 84286, 85508, 87383, 87384, 87935, 89745, 89746, 89766, 91015, 91016, 91018, 91019, 91020, 91021, 91336, 91388, 91750, 93492, 93506, 93511, 93512, 93514, 93515, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93568, 93584, 93591, 93592, 93594, 93598, 93599, 93600, 93604, 93605, 93606, 93607, 93608, 93934, 93982, 94253, 94254, 94257, 94258, 95770, 96178, 96179, 96180, 96182, 96183, 96184, 96185, 96186, 96187, 96188, 96189, 96192, 96193, 96194, 96195, 96196, 96197, 96198, 96199, 96200, 96201, 96203, 96204, 96209, 96846, 96851, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96863, 96867, 96868, 96869, 96872, 96874, 96875, 96876, 96877, 96878, 96879, 96880, 96881, 96882, 96883, 97620, 97621, 97622, 97623, 97624, 97792, 98183, 98186, 98417, 98420, 98421, 98432, 98490, 98491, 98521, 98698, 98699, 98700, 98701, 98702, 98703, 98704, 98705, 98706, 98707, 98708, 99370, 99371, 99372, 99373, 99374, 99375, 99376, 99377, 99378, 99379, 99380, 99381, 99382, 99383) AND `item_rank` <> 3 | 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` = 87935 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87935) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708911'))))) OR (((`item_id2` = 87935) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708911'))))) OR (((`item_id3` = 87935) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708911')))))) 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` = 96197 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96197) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25261G9A'))))) OR (((`item_id2` = 96197) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25261G9A'))))) OR (((`item_id3` = 96197) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25261G9A')))))) 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` = 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` = 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` = 6516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-N0001'))))) OR (((`item_id2` = 6516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-N0001'))))) OR (((`item_id3` = 6516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-N0001')))))) 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` = 98421 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98421) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36200'))))) OR (((`item_id2` = 98421) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36200'))))) OR (((`item_id3` = 98421) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36200')))))) 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` = 98491 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98491) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TE-0009-044'))))) OR (((`item_id2` = 98491) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TE-0009-044'))))) OR (((`item_id3` = 98491) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TE-0009-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` = 98521 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98521) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0152-044'))))) OR (((`item_id2` = 98521) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0152-044'))))) OR (((`item_id3` = 98521) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0152-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` = 98490 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98490) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TE-0009-009'))))) OR (((`item_id2` = 98490) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TE-0009-009'))))) OR (((`item_id3` = 98490) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TE-0009-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` = 6514 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6514) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-441G12A'))))) OR (((`item_id2` = 6514) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-441G12A'))))) OR (((`item_id3` = 6514) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-441G12A')))))) 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` = 98420 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98420) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36217'))))) OR (((`item_id2` = 98420) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36217'))))) OR (((`item_id3` = 98420) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36217')))))) 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` = 98186 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98186) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36128'))))) OR (((`item_id2` = 98186) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36128'))))) OR (((`item_id3` = 98186) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36128')))))) 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` = 97792 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97792) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374971'))))) OR (((`item_id2` = 97792) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374971'))))) OR (((`item_id3` = 97792) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374971')))))) 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 | 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` = 96876 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96876) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25267G6C'))))) OR (((`item_id2` = 96876) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25267G6C'))))) OR (((`item_id3` = 96876) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25267G6C')))))) 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` = 74291 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74291) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0911AB'))))) OR (((`item_id2` = 74291) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0911AB'))))) OR (((`item_id3` = 74291) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0911AB')))))) 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` = 98432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36124'))))) OR (((`item_id2` = 98432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36124'))))) OR (((`item_id3` = 98432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36124')))))) 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` = 98183 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98183) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36174'))))) OR (((`item_id2` = 98183) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36174'))))) OR (((`item_id3` = 98183) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36174')))))) 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` = 91336 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91336) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2284860'))))) OR (((`item_id2` = 91336) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2284860'))))) OR (((`item_id3` = 91336) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2284860')))))) 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` = 3829 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 3829) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '441G12A'))))) OR (((`item_id2` = 3829) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '441G12A'))))) OR (((`item_id3` = 3829) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '441G12A')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
![ノベルティ：[事務用品/オフィス用品] 卓上コンパクトクリーナー](/img/item/ThumbnailUS-2371721.jpg)
![ノベルティ：[A4バインダー] クリップファイル](/img/item/Thumbnail25261G09.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [事務用品/オフィス用品] コンパクトブラシ＆ダストパン](/img/item/ThumbnailTS-1641-009.jpg)
![ノベルティ：＜アウトレット売切廃盤＞ [事務用品/オフィス用品] コンパクトブラシ＆ダストパン](/img/item/ThumbnailTS-1641-044.jpg)
![ノベルティ：[粗品（文具）] A4クリアファイル 大きめ印刷 （送料無料、印刷0円）](/img/item/ThumbnailS-441G12.jpg)
![ノベルティ：[PRバッグ] アドバッグ40 小判抜きA4](/img/item/ThumbnailLC0911AB.jpg)
![ノベルティ：[粗品（文具）] A4クリアファイル 小さめ印刷 （送料無料、印刷0円）](/img/item/Thumbnail441G12.jpg)
