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 '%PET%') OR (`Item`.`item_name` Like '%PET%') OR (`Item`.`item_figure` Like '%PET%') OR (`Item`.`item_color` Like '%PET%') OR (`Item`.`item_materials` Like '%PET%') OR (`Item`.`item_note` Like '%PET%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 288 | 288 | 204 | 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 (35638, 35639, 35640, 64470, 64472, 64476, 65198, 65199, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 77225, 77225, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80804, 80804, 85210, 85505, 85530, 85636, 85637, 85638, 85639, 85640, 85641, 85722, 87252, 87315, 87702, 87702, 87702, 87822, 87844, 87845, 87856, 87856, 87857, 87858, 87859, 88884, 88885, 88886, 88887, 90319, 90457, 90689, 90689, 90690, 90690, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 91115, 91387, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91481, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 92499, 92500, 92540, 92549, 92906, 92907, 93007, 93008, 93051, 93600, 93608, 93933, 93938, 93938, 93955, 93985, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94360, 94361, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94571, 94572, 94761, 94861, 94861, 94862, 94862, 95087, 95159, 95163, 95166, 95167, 95168, 95169, 95185, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95245, 95347, 95348, 95349, 95432, 95432, 95433, 95433, 95770, 95780, 95924, 95925, 95926, 96410, 96411, 96412, 96413, 96475, 96476, 96477, 96478, 96755, 96756, 96765, 96766, 96881, 96960, 97376, 97388, 97609, 97719, 97793, 97797, 97798, 97811, 98065, 98066, 98067, 98068, 98069, 98181, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98667, 98705, 98706, 98707, 98712, 98752, 98811, 98813, 98814, 98815, 98816, 98817, 98821, 98822, 98848, 99282, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99456, 99550) 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 (35638, 35639, 35640, 64470, 64472, 64476, 65198, 65199, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 77225, 77225, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80804, 80804, 85210, 85505, 85530, 85636, 85637, 85638, 85639, 85640, 85641, 85722, 87252, 87315, 87702, 87702, 87702, 87822, 87844, 87845, 87856, 87856, 87857, 87858, 87859, 88884, 88885, 88886, 88887, 90319, 90457, 90689, 90689, 90690, 90690, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 91115, 91387, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91481, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 92499, 92500, 92540, 92549, 92906, 92907, 93007, 93008, 93051, 93600, 93608, 93933, 93938, 93938, 93955, 93985, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94360, 94361, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94571, 94572, 94761, 94861, 94861, 94862, 94862, 95087, 95159, 95163, 95166, 95167, 95168, 95169, 95185, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95245, 95347, 95348, 95349, 95432, 95432, 95433, 95433, 95770, 95780, 95924, 95925, 95926, 96410, 96411, 96412, 96413, 96475, 96476, 96477, 96478, 96755, 96756, 96765, 96766, 96881, 96960, 97376, 97388, 97609, 97719, 97793, 97797, 97798, 97811, 98065, 98066, 98067, 98068, 98069, 98181, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98667, 98705, 98706, 98707, 98712, 98752, 98811, 98813, 98814, 98815, 98816, 98817, 98821, 98822, 98848, 99282, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99456, 99550) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-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` = 98609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98620) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-034'))))) OR (((`item_id2` = 98620) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-034'))))) OR (((`item_id3` = 98620) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-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` = 98620 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98619) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-009'))))) OR (((`item_id2` = 98619) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-009'))))) OR (((`item_id3` = 98619) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-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` = 98619 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98618) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-006'))))) OR (((`item_id2` = 98618) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-006'))))) OR (((`item_id3` = 98618) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-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` = 98618 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98617) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-034'))))) OR (((`item_id2` = 98617) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-034'))))) OR (((`item_id3` = 98617) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-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` = 98617 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-009'))))) OR (((`item_id2` = 98616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-009'))))) OR (((`item_id3` = 98616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-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` = 98616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95167) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35720'))))) OR (((`item_id2` = 95167) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35720'))))) OR (((`item_id3` = 95167) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35720')))))) 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` = 95167 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-006'))))) OR (((`item_id2` = 98615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-006'))))) OR (((`item_id3` = 98615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-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` = 98615 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98614) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1370-034'))))) OR (((`item_id2` = 98614) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1370-034'))))) OR (((`item_id3` = 98614) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1370-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` = 98614 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98613) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1370-009'))))) OR (((`item_id2` = 98613) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1370-009'))))) OR (((`item_id3` = 98613) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1370-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` = 98613 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98612) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1370-006'))))) OR (((`item_id2` = 98612) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1370-006'))))) OR (((`item_id3` = 98612) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1370-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` = 98612 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98611) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-034'))))) OR (((`item_id2` = 98611) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-034'))))) OR (((`item_id3` = 98611) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-034')))))) 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` = 98611 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98610) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-009'))))) OR (((`item_id2` = 98610) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-009'))))) OR (((`item_id3` = 98610) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-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` = 98610 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1811-007'))))) OR (((`item_id2` = 94432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1811-007'))))) OR (((`item_id3` = 94432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1811-007')))))) 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` = 94432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91405) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1204-009'))))) OR (((`item_id2` = 91405) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1204-009'))))) OR (((`item_id3` = 91405) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1204-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` = 91405 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 | |