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 '%メモ%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 230 | 230 | 213 | 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`.`id` IN (35416, 35417, 35420, 35447, 35448, 35449, 35450, 38489, 38489, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 65720, 65721, 65722, 73643, 74767, 74768, 74768, 74769, 74769, 75746, 79423, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 82963, 82968, 82969, 83792, 83792, 83793, 83978, 83979, 83980, 83981, 84286, 84353, 84354, 84355, 84356, 84357, 84358, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 86969, 86970, 88191, 88396, 89117, 89140, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91759, 92496, 92522, 92523, 92535, 92536, 92539, 92547, 92548, 92550, 92553, 93154, 93226, 93246, 93346, 93347, 93348, 93492, 93514, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93982, 94546, 94547, 94548, 94549, 94763, 94867, 94868, 94869, 95158, 95238, 95241, 95243, 95313, 95314, 95315, 95316, 95362, 95363, 95364, 95364, 95365, 95365, 95603, 95638, 95639, 95640, 95641, 95770, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95973, 95974, 96403, 96404, 96406, 96638, 96872, 96883, 97620, 97621, 97622, 97623, 97624, 98009, 98010, 98011, 98012, 98013, 98014, 98114, 98171, 98183, 98432, 98490, 98491, 98529, 98530, 98535, 98536, 98626, 98936, 98937, 98938, 98941, 98942, 98943, 98944, 98945, 99287, 99288, 99289, 99290, 99338, 99339, 99584, 99585, 99586, 99615, 99616, 99734, 99743, 99745) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 15 | 15 | 15 | 3 | 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`.`id` IN (35416, 35417, 35420, 35447, 35448, 35449, 35450, 38489, 38489, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 65720, 65721, 65722, 73643, 74767, 74768, 74768, 74769, 74769, 75746, 79423, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 82963, 82968, 82969, 83792, 83792, 83793, 83978, 83979, 83980, 83981, 84286, 84353, 84354, 84355, 84356, 84357, 84358, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 86969, 86970, 88191, 88396, 89117, 89140, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91759, 92496, 92522, 92523, 92535, 92536, 92539, 92547, 92548, 92550, 92553, 93154, 93226, 93246, 93346, 93347, 93348, 93492, 93514, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93982, 94546, 94547, 94548, 94549, 94763, 94867, 94868, 94869, 95158, 95238, 95241, 95243, 95313, 95314, 95315, 95316, 95362, 95363, 95364, 95364, 95365, 95365, 95603, 95638, 95639, 95640, 95641, 95770, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95973, 95974, 96403, 96404, 96406, 96638, 96872, 96883, 97620, 97621, 97622, 97623, 97624, 98009, 98010, 98011, 98012, 98013, 98014, 98114, 98171, 98183, 98432, 98490, 98491, 98529, 98530, 98535, 98536, 98626, 98936, 98937, 98938, 98941, 98942, 98943, 98944, 98945, 99287, 99288, 99289, 99290, 99338, 99339, 99584, 99585, 99586, 99615, 99616, 99734, 99743, 99745) 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` = 38489) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0856-008'))))) OR (((`item_id2` = 38489) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0856-008'))))) OR (((`item_id3` = 38489) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0856-008')))))) ORDER BY `issue_date` desc LIMIT 1 | 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` = 38489 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80617) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-MEGS-S'))))) OR (((`item_id2` = 80617) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-MEGS-S'))))) OR (((`item_id3` = 80617) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-MEGS-S')))))) 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` = 80617 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35416) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0259-006'))))) OR (((`item_id2` = 35416) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0259-006'))))) OR (((`item_id3` = 35416) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0259-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 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` = 35416 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80614) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-PUSG-S'))))) OR (((`item_id2` = 80614) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-PUSG-S'))))) OR (((`item_id3` = 80614) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-PUSG-S')))))) 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` = 80614 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-ST-A'))))) OR (((`item_id2` = 80609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-ST-A'))))) OR (((`item_id3` = 80609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-ST-A')))))) 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` = 80609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 35450) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0496-044'))))) OR (((`item_id2` = 35450) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0496-044'))))) OR (((`item_id3` = 35450) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0496-044')))))) 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` = 35450 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54089) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1026-006'))))) OR (((`item_id2` = 54089) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1026-006'))))) OR (((`item_id3` = 54089) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1026-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` = 54089 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65720) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-151149'))))) OR (((`item_id2` = 65720) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-151149'))))) OR (((`item_id3` = 65720) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-151149')))))) 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` = 65720 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-LEGS-S'))))) OR (((`item_id2` = 80616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-LEGS-S'))))) OR (((`item_id3` = 80616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-LEGS-S')))))) 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` = 80616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73643) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-81410'))))) OR (((`item_id2` = 73643) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-81410'))))) OR (((`item_id3` = 73643) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-81410')))))) 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` = 73643 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35449) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0496-009'))))) OR (((`item_id2` = 35449) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0496-009'))))) OR (((`item_id3` = 35449) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0496-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` = 35449 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80597) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-EX-B'))))) OR (((`item_id2` = 80597) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-EX-B'))))) OR (((`item_id3` = 80597) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-EX-B')))))) 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` = 80597 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80588) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-TW-A'))))) OR (((`item_id2` = 80588) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-TW-A'))))) OR (((`item_id3` = 80588) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-TW-A')))))) 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` = 80588 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-MAGS-S'))))) OR (((`item_id2` = 80615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-MAGS-S'))))) OR (((`item_id3` = 80615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-MAGS-S')))))) 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` = 80615 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 | |