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 '%300%') OR (`Item`.`item_name` Like '%300%') OR (`Item`.`item_figure` Like '%300%') OR (`Item`.`item_color` Like '%300%') OR (`Item`.`item_materials` Like '%300%') OR (`Item`.`item_note` Like '%300%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 234 | 234 | 323 | 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 (6516, 12965, 29196, 34960, 34961, 34965, 34968, 35252, 35536, 35537, 35625, 35626, 57747, 64542, 66672, 69379, 73051, 73051, 73187, 73187, 73206, 73206, 73216, 73216, 73692, 73693, 74787, 74788, 74944, 75431, 75432, 75433, 75434, 76933, 77319, 78053, 78054, 78142, 79023, 79023, 80734, 80735, 81905, 82911, 84097, 84257, 85694, 85695, 86010, 86074, 86078, 86357, 87271, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87391, 87391, 87392, 87392, 87393, 87393, 87665, 87775, 87776, 87777, 87778, 87796, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88195, 88196, 88197, 88222, 88223, 88229, 88229, 88280, 89837, 90048, 90433, 90434, 90435, 90689, 90689, 90690, 90690, 90764, 90765, 90766, 90960, 90961, 90962, 91121, 91121, 91488, 91718, 91718, 91933, 92074, 92253, 92254, 92523, 92676, 92677, 92678, 92695, 92696, 92724, 92725, 92729, 92730, 92731, 92732, 92891, 93214, 93229, 93261, 93392, 93979, 94036, 94265, 94265, 94323, 94324, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94797, 94803, 95145, 95146, 95147, 95233, 95234, 95557, 95558, 95658, 95659, 95660, 95661, 95900, 96016, 96254, 96266, 96316, 96554, 96897, 96898, 96899, 96900, 96938, 97045, 97059, 97106, 97107, 97108, 97122, 97135, 97136, 97159, 97605, 97606, 97806, 97828, 97830, 98073, 98074, 98075, 98162, 98593, 98594, 98595, 98596, 98597, 98598, 98801, 98811, 98890, 98891, 98892, 98900, 98901, 98902, 98955, 98956, 99123, 99319, 99652, 99700, 99707, 99726, 99727, 99728, 99729) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 1 | 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 (6516, 12965, 29196, 34960, 34961, 34965, 34968, 35252, 35536, 35537, 35625, 35626, 57747, 64542, 66672, 69379, 73051, 73051, 73187, 73187, 73206, 73206, 73216, 73216, 73692, 73693, 74787, 74788, 74944, 75431, 75432, 75433, 75434, 76933, 77319, 78053, 78054, 78142, 79023, 79023, 80734, 80735, 81905, 82911, 84097, 84257, 85694, 85695, 86010, 86074, 86078, 86357, 87271, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87391, 87391, 87392, 87392, 87393, 87393, 87665, 87775, 87776, 87777, 87778, 87796, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88195, 88196, 88197, 88222, 88223, 88229, 88229, 88280, 89837, 90048, 90433, 90434, 90435, 90689, 90689, 90690, 90690, 90764, 90765, 90766, 90960, 90961, 90962, 91121, 91121, 91488, 91718, 91718, 91933, 92074, 92253, 92254, 92523, 92676, 92677, 92678, 92695, 92696, 92724, 92725, 92729, 92730, 92731, 92732, 92891, 93214, 93229, 93261, 93392, 93979, 94036, 94265, 94265, 94323, 94324, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94797, 94803, 95145, 95146, 95147, 95233, 95234, 95557, 95558, 95658, 95659, 95660, 95661, 95900, 96016, 96254, 96266, 96316, 96554, 96897, 96898, 96899, 96900, 96938, 97045, 97059, 97106, 97107, 97108, 97122, 97135, 97136, 97159, 97605, 97606, 97806, 97828, 97830, 98073, 98074, 98075, 98162, 98593, 98594, 98595, 98596, 98597, 98598, 98801, 98811, 98890, 98891, 98892, 98900, 98901, 98902, 98955, 98956, 99123, 99319, 99652, 99700, 99707, 99726, 99727, 99728, 99729) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89837) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25204G5'))))) OR (((`item_id2` = 89837) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25204G5'))))) OR (((`item_id3` = 89837) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25204G5')))))) 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` = 89837 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79023) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G8'))))) OR (((`item_id2` = 79023) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G8'))))) OR (((`item_id3` = 79023) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G8')))))) 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` = 79023 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 12965) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206849'))))) OR (((`item_id2` = 12965) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206849'))))) OR (((`item_id3` = 12965) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206849')))))) 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` = 12965 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95233) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1300-008'))))) OR (((`item_id2` = 95233) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1300-008'))))) OR (((`item_id3` = 95233) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1300-008')))))) 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` = 95233 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92074) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25300G3'))))) OR (((`item_id2` = 92074) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25300G3'))))) OR (((`item_id3` = 92074) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25300G3')))))) 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` = 92074 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 | 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` = 98594) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-008'))))) OR (((`item_id2` = 98594) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-008'))))) OR (((`item_id3` = 98594) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-008')))))) 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` = 98594 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98593) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-006'))))) OR (((`item_id2` = 98593) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-006'))))) OR (((`item_id3` = 98593) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98593 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98598) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-045'))))) OR (((`item_id2` = 98598) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-045'))))) OR (((`item_id3` = 98598) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-045')))))) 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` = 98598 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98597) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-034'))))) OR (((`item_id2` = 98597) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-034'))))) OR (((`item_id3` = 98597) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98597 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98596) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-011'))))) OR (((`item_id2` = 98596) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-011'))))) OR (((`item_id3` = 98596) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-011')))))) 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` = 98596 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98595) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-009'))))) OR (((`item_id2` = 98595) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-009'))))) OR (((`item_id3` = 98595) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98595 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95558) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1699-028'))))) OR (((`item_id2` = 95558) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1699-028'))))) OR (((`item_id3` = 95558) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1699-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` = 95558 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97830) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476677'))))) OR (((`item_id2` = 97830) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476677'))))) OR (((`item_id3` = 97830) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476677')))))) 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` = 97830 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77319) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-180347'))))) OR (((`item_id2` = 77319) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-180347'))))) OR (((`item_id3` = 77319) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-180347')))))) 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` = 77319 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 | |