| 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` = 3 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 147 | 147 | 26 | maybe slow |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 3 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 (34874, 34875, 34885, 34886, 48175, 48176, 57632, 57641, 58215, 64465, 65209, 73527, 73528, 73657, 73658, 73665, 73666, 73678, 77225, 77610, 77611, 77614, 77615, 77616, 77617, 77755, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80610, 80611, 80612, 80613, 80614, 80615, 80616, 80617, 84421, 85210, 87407, 87408, 87851, 87906, 87907, 87908, 87913, 87914, 88191, 88396, 90427, 90428, 90750, 90751, 90752, 90753, 91012, 91013, 91015, 91016, 91017, 91018, 91019, 91020, 91021, 91137, 91322, 91487, 91589, 91590, 91591, 91592, 91647, 91676, 91677, 91718, 91739, 91759, 94255, 94256, 94257, 94258, 94277, 94290, 94291, 94292, 94339, 94559, 94595, 94596, 94598, 94599, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94772, 94775, 94828, 94830, 95135, 95136, 95309, 95362, 95363, 96386, 96387, 96388, 96389, 96390, 96392, 96393, 97383, 97618, 97619, 98153, 98721, 98722, 98723, 98724, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 99287, 99288, 99289, 99290, 99291, 99292) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 1 | 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 (95362, 94599, 34874, 94775, 91137, 98153, 91591, 90752, 87407, 91718, 95135, 97619, 97618, 97383, 95363, 91021, 91647, 91016, 95309, 80612) | 33 | 33 | 21 | 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 (34874, 34875, 34885, 34886, 48175, 48176, 57632, 57641, 58215, 64465, 65209, 73527, 73528, 73657, 73658, 73665, 73666, 73678, 77225, 77610, 77611, 77614, 77615, 77616, 77617, 77755, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80610, 80611, 80612, 80613, 80614, 80615, 80616, 80617, 84421, 85210, 87407, 87408, 87851, 87906, 87907, 87908, 87913, 87914, 88191, 88396, 90427, 90428, 90750, 90751, 90752, 90753, 91012, 91013, 91015, 91016, 91017, 91018, 91019, 91020, 91021, 91137, 91322, 91487, 91589, 91590, 91591, 91592, 91647, 91676, 91677, 91718, 91739, 91759, 94255, 94256, 94257, 94258, 94277, 94290, 94291, 94292, 94339, 94559, 94595, 94596, 94598, 94599, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94772, 94775, 94828, 94830, 95135, 95136, 95309, 95362, 95363, 96386, 96387, 96388, 96389, 96390, 96392, 96393, 97383, 97618, 97619, 98153, 98721, 98722, 98723, 98724, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 99287, 99288, 99289, 99290, 99291, 99292) 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` = 95362 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325070'))))) OR (((`item_id2` = 95362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325070'))))) OR (((`item_id3` = 95362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325070')))))) 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` = 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 | 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` = 34874 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34874) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0342-006'))))) OR (((`item_id2` = 34874) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0342-006'))))) OR (((`item_id3` = 34874) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0342-006')))))) 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` = 94775 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94775) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2284000'))))) OR (((`item_id2` = 94775) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2284000'))))) OR (((`item_id3` = 94775) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2284000')))))) 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` = 91137 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91137) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-34841'))))) OR (((`item_id2` = 91137) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-34841'))))) OR (((`item_id3` = 91137) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-34841')))))) 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` = 98153 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98153) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36191'))))) OR (((`item_id2` = 98153) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36191'))))) OR (((`item_id3` = 98153) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36191')))))) 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` = 91591 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91591) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1802-034'))))) OR (((`item_id2` = 91591) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1802-034'))))) OR (((`item_id3` = 91591) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1802-034')))))) 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` = 90752 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90752) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1724-034'))))) OR (((`item_id2` = 90752) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1724-034'))))) OR (((`item_id3` = 90752) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1724-034')))))) 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` = 87407 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87407) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1636-009'))))) OR (((`item_id2` = 87407) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1636-009'))))) OR (((`item_id3` = 87407) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1636-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` = 91718 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91718) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-64019WH'))))) OR (((`item_id2` = 91718) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-64019WH'))))) OR (((`item_id3` = 91718) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-64019WH')))))) 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` = 95135 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95135) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1845-009'))))) OR (((`item_id2` = 95135) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1845-009'))))) OR (((`item_id3` = 95135) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1845-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` = 97619 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97619) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313646'))))) OR (((`item_id2` = 97619) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313646'))))) OR (((`item_id3` = 97619) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313646')))))) 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` = 97618 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97618) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313547'))))) OR (((`item_id2` = 97618) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313547'))))) OR (((`item_id3` = 97618) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313547')))))) 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` = 97383 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374591'))))) OR (((`item_id2` = 97383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374591'))))) OR (((`item_id3` = 97383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374591')))))) 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` = 95363 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95363) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325080'))))) OR (((`item_id2` = 95363) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325080'))))) OR (((`item_id3` = 95363) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325080')))))) 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` = 91021 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91021) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1746-044'))))) OR (((`item_id2` = 91021) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1746-044'))))) OR (((`item_id3` = 91021) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1746-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` = 91647 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91647) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1800-044'))))) OR (((`item_id2` = 91647) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1800-044'))))) OR (((`item_id3` = 91647) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1800-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` = 91016 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91016) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1744-044'))))) OR (((`item_id2` = 91016) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1744-044'))))) OR (((`item_id3` = 91016) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1744-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` = 95309 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95309) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0122-005'))))) OR (((`item_id2` = 95309) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0122-005'))))) OR (((`item_id3` = 95309) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0122-005')))))) 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` = 80612 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80612) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-FC-A'))))) OR (((`item_id2` = 80612) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-FC-A'))))) OR (((`item_id3` = 80612) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-FC-A')))))) 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)
![ノベルティ：[PC周辺グッズ] もちもちあにまる アームレスト](/img/item/ThumbnailUS-2373731.jpg)
