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 '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_name` Like '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_figure` Like '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_color` Like '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_materials` Like '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_note` Like '%ルンルンB.B.タッチ滅菌済絆創膏%') OR (`Item`.`item_code` Like '%5枚%') OR (`Item`.`item_name` Like '%5枚%') OR (`Item`.`item_figure` Like '%5枚%') OR (`Item`.`item_color` Like '%5枚%') OR (`Item`.`item_materials` Like '%5枚%') OR (`Item`.`item_note` Like '%5枚%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 205 | 205 | 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_rank` = 1 AND `Item`.`id` IN (6173, 35416, 35417, 35420, 54087, 54089, 54090, 70203, 73052, 73052, 73062, 73062, 73176, 73176, 73276, 73276, 81567, 81567, 81567, 81568, 81568, 81568, 83120, 83160, 83532, 83936, 85491, 85505, 85768, 87286, 87291, 87291, 89456, 89456, 89532, 89539, 91795, 92517, 92518, 92519, 92520, 92523, 92524, 92539, 92550, 92552, 93002, 93003, 93004, 93005, 93055, 93056, 93058, 93214, 93226, 93251, 93968, 95085, 95158, 95239, 95240, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95900, 95901, 95902, 95903, 96285, 96299, 96300, 96303, 96305, 96329, 96403, 96404, 96743, 96760, 96762, 96767, 97121, 97122, 97123, 97124, 97125, 97155, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98116, 98475, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98763, 98809, 99297, 99730, 99742, 99747) 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`.`item_rank` = 1 AND `Item`.`id` IN (6173, 35416, 35417, 35420, 54087, 54089, 54090, 70203, 73052, 73052, 73062, 73062, 73176, 73176, 73276, 73276, 81567, 81567, 81567, 81568, 81568, 81568, 83120, 83160, 83532, 83936, 85491, 85505, 85768, 87286, 87291, 87291, 89456, 89456, 89532, 89539, 91795, 92517, 92518, 92519, 92520, 92523, 92524, 92539, 92550, 92552, 93002, 93003, 93004, 93005, 93055, 93056, 93058, 93214, 93226, 93251, 93968, 95085, 95158, 95239, 95240, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95900, 95901, 95902, 95903, 96285, 96299, 96300, 96303, 96305, 96329, 96403, 96404, 96743, 96760, 96762, 96767, 97121, 97122, 97123, 97124, 97125, 97155, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98116, 98475, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98763, 98809, 99297, 99730, 99742, 99747) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6173) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h144-033445'))))) OR (((`item_id2` = 6173) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h144-033445'))))) OR (((`item_id3` = 6173) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h144-033445')))))) 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` = 6173 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25285G9A'))))) OR (((`item_id2` = 92517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25285G9A'))))) OR (((`item_id3` = 92517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25285G9A')))))) 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` = 92517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73062) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25288G7'))))) OR (((`item_id2` = 73062) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25288G7'))))) OR (((`item_id3` = 73062) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25288G7')))))) 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` = 73062 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91795) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25331G12'))))) OR (((`item_id2` = 91795) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25331G12'))))) OR (((`item_id3` = 91795) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25331G12')))))) 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` = 91795 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98564) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-044'))))) OR (((`item_id2` = 98564) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-044'))))) OR (((`item_id3` = 98564) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98564 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92539) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25318G3'))))) OR (((`item_id2` = 92539) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25318G3'))))) OR (((`item_id3` = 92539) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25318G3')))))) 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` = 92539 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98563) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-034'))))) OR (((`item_id2` = 98563) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-034'))))) OR (((`item_id3` = 98563) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98563 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98562) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-028'))))) OR (((`item_id2` = 98562) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-028'))))) OR (((`item_id3` = 98562) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98562 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98592) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-044'))))) OR (((`item_id2` = 98592) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-044'))))) OR (((`item_id3` = 98592) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-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` = 98592 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98561) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-009'))))) OR (((`item_id2` = 98561) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-009'))))) OR (((`item_id3` = 98561) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98561 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98591) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-030'))))) OR (((`item_id2` = 98591) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-030'))))) OR (((`item_id3` = 98591) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-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` = 98591 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98546) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-045'))))) OR (((`item_id2` = 98546) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-045'))))) OR (((`item_id3` = 98546) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-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` = 98546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98560) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0025-044'))))) OR (((`item_id2` = 98560) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0025-044'))))) OR (((`item_id3` = 98560) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0025-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` = 98560 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98590) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-009'))))) OR (((`item_id2` = 98590) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-009'))))) OR (((`item_id3` = 98590) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-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` = 98590 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98545) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-044'))))) OR (((`item_id2` = 98545) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-044'))))) OR (((`item_id3` = 98545) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-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` = 98545 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 | |