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 `Category`.`id`, `Category`.`words` 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 ((`Item`.`item_code` Like '%[アウトドア]%') OR (`Item`.`item_name` Like '%[アウトドア]%') OR (`Item`.`item_figure` Like '%[アウトドア]%') OR (`Item`.`item_color` Like '%[アウトドア]%') OR (`Item`.`item_materials` Like '%[アウトドア]%') OR (`Item`.`item_note` Like '%[アウトドア]%') OR (`Item`.`item_code` Like '%キャプテンスタッグ%') OR (`Item`.`item_name` Like '%キャプテンスタッグ%') OR (`Item`.`item_figure` Like '%キャプテンスタッグ%') OR (`Item`.`item_color` Like '%キャプテンスタッグ%') OR (`Item`.`item_materials` Like '%キャプテンスタッグ%') OR (`Item`.`item_note` Like '%キャプテンスタッグ%') OR (`Item`.`item_code` Like '%マルチ%') OR (`Item`.`item_name` Like '%マルチ%') OR (`Item`.`item_figure` Like '%マルチ%') OR (`Item`.`item_color` Like '%マルチ%') OR (`Item`.`item_materials` Like '%マルチ%') OR (`Item`.`item_note` Like '%マルチ%') OR (`Item`.`item_code` Like '%ミニバーベキュー%') OR (`Item`.`item_name` Like '%ミニバーベキュー%') OR (`Item`.`item_figure` Like '%ミニバーベキュー%') OR (`Item`.`item_color` Like '%ミニバーベキュー%') OR (`Item`.`item_materials` Like '%ミニバーベキュー%') OR (`Item`.`item_note` Like '%ミニバーベキュー%') OR (`Item`.`item_code` Like '%コンロ%') OR (`Item`.`item_name` Like '%コンロ%') OR (`Item`.`item_figure` Like '%コンロ%') OR (`Item`.`item_color` Like '%コンロ%') OR (`Item`.`item_materials` Like '%コンロ%') OR (`Item`.`item_note` Like '%コンロ%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 263 | 263 | 852 | maybe slow |
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 (35105, 35243, 35244, 35245, 35263, 35264, 35416, 35417, 35420, 35593, 35692, 35693, 36334, 38489, 38489, 44709, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 64661, 64662, 64663, 64664, 64665, 64666, 65251, 65252, 65373, 73772, 73773, 73774, 73775, 73834, 77162, 77163, 77164, 77165, 77166, 77166, 77167, 77167, 77186, 77188, 77191, 77191, 77230, 77230, 77230, 81109, 81109, 81109, 83532, 83879, 83881, 83927, 84151, 84482, 84482, 84483, 84483, 85412, 86079, 87378, 87379, 87813, 88685, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90429, 90429, 90430, 90430, 90462, 90889, 90890, 90891, 90892, 90893, 91118, 91122, 91322, 91322, 91389, 91399, 91401, 91506, 91507, 91507, 91511, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91914, 91957, 92436, 92615, 92641, 92673, 92988, 92995, 92999, 93598, 93945, 93985, 94365, 94365, 94366, 94369, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94863, 94864, 94865, 94866, 95096, 95183, 95189, 95189, 95498, 95499, 95500, 95501, 95603, 95618, 95619, 95620, 95665, 95666, 95772, 95779, 95779, 95785, 95785, 95791, 95792, 95793, 95806, 95940, 95941, 96425, 96431, 96446, 96475, 96476, 96477, 96478, 96641, 96756, 96802, 96929, 96930, 96932, 96933, 97378, 97682, 97683, 97684, 97685, 97693, 97694, 97695, 97696, 97839, 98117, 98117, 98120, 98125, 98125, 98126, 98187, 98188, 98440, 98440, 98440, 98444, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98577, 98578, 98579, 98580, 98585, 98586, 98587, 98588, 98642, 98643, 98644, 98645, 98731, 98732, 98733, 98734, 98862, 98863, 98890, 98891, 98892, 99344, 99345, 99346, 99355, 99414, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99672, 99729, 99740) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` desc LIMIT 15 | 15 | 15 | 2 | 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 (35105, 35243, 35244, 35245, 35263, 35264, 35416, 35417, 35420, 35593, 35692, 35693, 36334, 38489, 38489, 44709, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 64661, 64662, 64663, 64664, 64665, 64666, 65251, 65252, 65373, 73772, 73773, 73774, 73775, 73834, 77162, 77163, 77164, 77165, 77166, 77166, 77167, 77167, 77186, 77188, 77191, 77191, 77230, 77230, 77230, 81109, 81109, 81109, 83532, 83879, 83881, 83927, 84151, 84482, 84482, 84483, 84483, 85412, 86079, 87378, 87379, 87813, 88685, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90429, 90429, 90430, 90430, 90462, 90889, 90890, 90891, 90892, 90893, 91118, 91122, 91322, 91322, 91389, 91399, 91401, 91506, 91507, 91507, 91511, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91914, 91957, 92436, 92615, 92641, 92673, 92988, 92995, 92999, 93598, 93945, 93985, 94365, 94365, 94366, 94369, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94863, 94864, 94865, 94866, 95096, 95183, 95189, 95189, 95498, 95499, 95500, 95501, 95603, 95618, 95619, 95620, 95665, 95666, 95772, 95779, 95779, 95785, 95785, 95791, 95792, 95793, 95806, 95940, 95941, 96425, 96431, 96446, 96475, 96476, 96477, 96478, 96641, 96756, 96802, 96929, 96930, 96932, 96933, 97378, 97682, 97683, 97684, 97685, 97693, 97694, 97695, 97696, 97839, 98117, 98117, 98120, 98125, 98125, 98126, 98187, 98188, 98440, 98440, 98440, 98444, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98577, 98578, 98579, 98580, 98585, 98586, 98587, 98588, 98642, 98643, 98644, 98645, 98731, 98732, 98733, 98734, 98862, 98863, 98890, 98891, 98892, 99344, 99345, 99346, 99355, 99414, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99672, 99729, 99740) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92641) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G1'))))) OR (((`item_id2` = 92641) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G1'))))) OR (((`item_id3` = 92641) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G1')))))) 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` = 92641 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95940) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2594G3'))))) OR (((`item_id2` = 95940) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2594G3'))))) OR (((`item_id3` = 95940) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2594G3')))))) 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` = 95940 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98890) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2569G5A'))))) OR (((`item_id2` = 98890) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2569G5A'))))) OR (((`item_id3` = 98890) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2569G5A')))))) 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` = 98890 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98891) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2569G5B'))))) OR (((`item_id2` = 98891) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2569G5B'))))) OR (((`item_id3` = 98891) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2569G5B')))))) 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` = 98891 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98892) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2569G5C'))))) OR (((`item_id2` = 98892) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2569G5C'))))) OR (((`item_id3` = 98892) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2569G5C')))))) 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` = 98892 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92988) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2534G1'))))) OR (((`item_id2` = 92988) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2534G1'))))) OR (((`item_id3` = 92988) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2534G1')))))) 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` = 92988 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G4'))))) OR (((`item_id2` = 92615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G4'))))) OR (((`item_id3` = 92615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G4')))))) 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` = 92615 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95941) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2594G4'))))) OR (((`item_id2` = 95941) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2594G4'))))) OR (((`item_id3` = 95941) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2594G4')))))) 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` = 95941 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96802) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2548G5'))))) OR (((`item_id2` = 96802) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2548G5'))))) OR (((`item_id3` = 96802) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2548G5')))))) 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` = 96802 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96641) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2534G3'))))) OR (((`item_id2` = 96641) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2534G3'))))) OR (((`item_id3` = 96641) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2534G3')))))) 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` = 96641 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96929) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2564G2'))))) OR (((`item_id2` = 96929) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2564G2'))))) OR (((`item_id3` = 96929) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2564G2')))))) 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` = 96929 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98642) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G2A'))))) OR (((`item_id2` = 98642) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G2A'))))) OR (((`item_id3` = 98642) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G2A')))))) 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` = 98642 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98643) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G2B'))))) OR (((`item_id2` = 98643) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G2B'))))) OR (((`item_id3` = 98643) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G2B')))))) 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` = 98643 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98644) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G2C'))))) OR (((`item_id2` = 98644) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G2C'))))) OR (((`item_id3` = 98644) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G2C')))))) 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` = 98644 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G2D'))))) OR (((`item_id2` = 98645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G2D'))))) OR (((`item_id3` = 98645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G2D')))))) 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` = 98645 AND `Questionnaire`.`publish_flg` = 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 | |