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 | 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`.`item_naming` = 1 AND `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` asc 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`.`item_naming` = 1 AND `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` = 91957) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25324G4'))))) OR (((`item_id2` = 91957) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25324G4'))))) OR (((`item_id3` = 91957) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25324G4')))))) 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` = 91957 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35105) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0452-030'))))) OR (((`item_id2` = 35105) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0452-030'))))) OR (((`item_id3` = 35105) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0452-030')))))) 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` = 35105 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99740) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25314G10D'))))) OR (((`item_id2` = 99740) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25314G10D'))))) OR (((`item_id3` = 99740) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25314G10D')))))) 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` = 99740 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96756) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25310G8'))))) OR (((`item_id2` = 96756) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25310G8'))))) OR (((`item_id3` = 96756) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25310G8')))))) 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` = 96756 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91914) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25303G12'))))) OR (((`item_id2` = 91914) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25303G12'))))) OR (((`item_id3` = 91914) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25303G12')))))) 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` = 91914 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93598) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25298G6'))))) OR (((`item_id2` = 93598) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25298G6'))))) OR (((`item_id3` = 93598) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25298G6')))))) 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` = 93598 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95772) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35891'))))) OR (((`item_id2` = 95772) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35891'))))) OR (((`item_id3` = 95772) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35891')))))) 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` = 95772 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99729) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25300G7D'))))) OR (((`item_id2` = 99729) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25300G7D'))))) OR (((`item_id3` = 99729) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25300G7D')))))) 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` = 99729 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81109) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-31732'))))) OR (((`item_id2` = 81109) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-31732'))))) OR (((`item_id3` = 81109) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-31732')))))) 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` = 81109 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54083) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1025-050'))))) OR (((`item_id2` = 54083) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1025-050'))))) OR (((`item_id3` = 54083) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1025-050')))))) 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` = 54083 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54085) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1025-006'))))) OR (((`item_id2` = 54085) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1025-006'))))) OR (((`item_id3` = 54085) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1025-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` = 54085 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54086) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1025-009'))))) OR (((`item_id2` = 54086) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1025-009'))))) OR (((`item_id3` = 54086) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1025-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` = 54086 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95183) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35711'))))) OR (((`item_id2` = 95183) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35711'))))) OR (((`item_id3` = 95183) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35711')))))) 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` = 95183 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98577) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-009'))))) OR (((`item_id2` = 98577) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-009'))))) OR (((`item_id3` = 98577) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-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` = 98577 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98578) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-028'))))) OR (((`item_id2` = 98578) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-028'))))) OR (((`item_id3` = 98578) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-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` = 98578 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 | |