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 '%インテリア電波時計%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 183 | 183 | 340 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_rank` = 1 AND `Item`.`id` IN (35695, 57695, 57696, 57697, 70489, 77330, 78017, 78018, 78019, 80097, 80609, 80609, 80610, 80610, 80611, 80611, 80729, 80730, 81109, 81109, 81109, 81216, 81216, 81229, 81245, 81496, 81497, 81498, 81499, 81499, 81500, 83796, 83796, 83812, 83813, 83942, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84517, 84518, 85798, 86049, 87783, 87784, 87785, 87786, 87919, 89033, 89034, 91336, 91393, 91394, 91480, 91488, 91800, 92300, 92769, 92994, 93591, 94253, 94253, 94254, 94254, 94357, 94358, 94509, 94510, 94511, 94512, 94571, 94572, 94613, 94614, 94615, 94616, 94743, 95313, 95314, 95315, 95316, 95372, 95414, 95610, 95613, 95634, 95635, 95636, 95637, 96355, 96450, 96855, 97686, 97687, 97693, 97694, 97695, 97696, 97805, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98148, 98148, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98628, 98666, 98796, 98908, 98909, 98911, 99246, 99755, 99756) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 30, 15 | 15 | 15 | 4 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_rank` = 1 AND `Item`.`id` IN (35695, 57695, 57696, 57697, 70489, 77330, 78017, 78018, 78019, 80097, 80609, 80609, 80610, 80610, 80611, 80611, 80729, 80730, 81109, 81109, 81109, 81216, 81216, 81229, 81245, 81496, 81497, 81498, 81499, 81499, 81500, 83796, 83796, 83812, 83813, 83942, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84517, 84518, 85798, 86049, 87783, 87784, 87785, 87786, 87919, 89033, 89034, 91336, 91393, 91394, 91480, 91488, 91800, 92300, 92769, 92994, 93591, 94253, 94253, 94254, 94254, 94357, 94358, 94509, 94510, 94511, 94512, 94571, 94572, 94613, 94614, 94615, 94616, 94743, 95313, 95314, 95315, 95316, 95372, 95414, 95610, 95613, 95634, 95635, 95636, 95637, 96355, 96450, 96855, 97686, 97687, 97693, 97694, 97695, 97696, 97805, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98148, 98148, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98628, 98666, 98796, 98908, 98909, 98911, 99246, 99755, 99756) AND `item_rank` <> 3 | 1 | 1 | 2 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84502) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1506-009'))))) OR (((`item_id2` = 84502) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1506-009'))))) OR (((`item_id3` = 84502) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1506-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` = 84502 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89033) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25277G5A'))))) OR (((`item_id2` = 89033) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25277G5A'))))) OR (((`item_id3` = 89033) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25277G5A')))))) 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` = 89033 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84496) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1507-044'))))) OR (((`item_id2` = 84496) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1507-044'))))) OR (((`item_id3` = 84496) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1507-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` = 84496 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87786) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-265242'))))) OR (((`item_id2` = 87786) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-265242'))))) OR (((`item_id3` = 87786) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-265242')))))) 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` = 87786 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84499) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1507-006'))))) OR (((`item_id2` = 84499) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1507-006'))))) OR (((`item_id3` = 84499) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1507-006')))))) 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` = 84499 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87784) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-265143'))))) OR (((`item_id2` = 87784) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-265143'))))) OR (((`item_id3` = 87784) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-265143')))))) 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` = 87784 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84500) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1507-011'))))) OR (((`item_id2` = 84500) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1507-011'))))) OR (((`item_id3` = 84500) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1507-011')))))) 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` = 84500 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87785) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-264948'))))) OR (((`item_id2` = 87785) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-264948'))))) OR (((`item_id3` = 87785) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-264948')))))) 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` = 87785 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81229) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2023730'))))) OR (((`item_id2` = 81229) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2023730'))))) OR (((`item_id3` = 81229) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2023730')))))) 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` = 81229 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84497) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1507-009'))))) OR (((`item_id2` = 84497) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1507-009'))))) OR (((`item_id3` = 84497) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1507-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` = 84497 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84505) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1506-011'))))) OR (((`item_id2` = 84505) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1506-011'))))) OR (((`item_id3` = 84505) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1506-011')))))) 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` = 84505 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87783) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-265044'))))) OR (((`item_id2` = 87783) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-265044'))))) OR (((`item_id3` = 87783) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-265044')))))) 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` = 87783 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87919) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1673-005'))))) OR (((`item_id2` = 87919) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1673-005'))))) OR (((`item_id3` = 87919) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1673-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` = 87919 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1833-009'))))) OR (((`item_id2` = 94616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1833-009'))))) OR (((`item_id3` = 94616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1833-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` = 94616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94253) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-283840'))))) OR (((`item_id2` = 94253) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-283840'))))) OR (((`item_id3` = 94253) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-283840')))))) 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` = 94253 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |