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 '%ファイン%') 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 | 251 | 251 | 453 | 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, 12380, 12381, 12382, 28880, 34936, 34936, 57644, 57645, 64481, 64556, 64556, 64557, 64557, 73056, 76933, 77081, 77141, 79229, 79229, 81905, 83844, 83845, 83846, 83936, 84262, 84984, 84984, 84984, 85017, 85017, 85017, 85446, 85447, 85448, 85449, 85450, 85451, 85452, 85453, 85464, 85814, 85815, 86583, 86932, 87286, 87295, 87295, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87413, 87906, 87907, 87908, 88497, 88498, 88499, 89312, 89456, 89456, 89745, 89746, 90231, 90691, 90692, 90693, 90694, 91011, 91012, 91013, 91975, 91976, 91998, 91999, 92000, 92108, 92114, 92833, 92847, 92866, 92867, 93123, 93189, 93226, 93979, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94757, 94758, 94759, 94763, 95120, 95410, 95412, 95598, 95599, 95600, 95601, 95829, 95951, 96238, 96288, 96293, 96294, 96298, 96306, 96309, 96316, 96317, 96336, 96342, 96343, 96346, 96349, 96406, 96419, 96420, 96421, 96491, 96492, 96493, 96494, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96746, 96748, 96755, 96765, 96766, 96769, 96971, 96972, 97035, 97036, 97038, 97128, 97129, 97160, 97182, 97726, 97726, 97806, 97830, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 98207, 98212, 98223, 98488, 98489, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98699, 98716, 98815, 98816, 98817, 98821, 98822, 98907, 98913, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99172, 99197, 99198, 99199, 99505, 99707, 99708, 99709, 99710, 99720, 99721, 99722, 99747, 99752, 99753, 99754, 99755, 99756, 99757, 99758) 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, 12380, 12381, 12382, 28880, 34936, 34936, 57644, 57645, 64481, 64556, 64556, 64557, 64557, 73056, 76933, 77081, 77141, 79229, 79229, 81905, 83844, 83845, 83846, 83936, 84262, 84984, 84984, 84984, 85017, 85017, 85017, 85446, 85447, 85448, 85449, 85450, 85451, 85452, 85453, 85464, 85814, 85815, 86583, 86932, 87286, 87295, 87295, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87413, 87906, 87907, 87908, 88497, 88498, 88499, 89312, 89456, 89456, 89745, 89746, 90231, 90691, 90692, 90693, 90694, 91011, 91012, 91013, 91975, 91976, 91998, 91999, 92000, 92108, 92114, 92833, 92847, 92866, 92867, 93123, 93189, 93226, 93979, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94757, 94758, 94759, 94763, 95120, 95410, 95412, 95598, 95599, 95600, 95601, 95829, 95951, 96238, 96288, 96293, 96294, 96298, 96306, 96309, 96316, 96317, 96336, 96342, 96343, 96346, 96349, 96406, 96419, 96420, 96421, 96491, 96492, 96493, 96494, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96746, 96748, 96755, 96765, 96766, 96769, 96971, 96972, 97035, 97036, 97038, 97128, 97129, 97160, 97182, 97726, 97726, 97806, 97830, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 98207, 98212, 98223, 98488, 98489, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98699, 98716, 98815, 98816, 98817, 98821, 98822, 98907, 98913, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99172, 99197, 99198, 99199, 99505, 99707, 99708, 99709, 99710, 99720, 99721, 99722, 99747, 99752, 99753, 99754, 99755, 99756, 99757, 99758) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84984) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 's-wt1A-a'))))) OR (((`item_id2` = 84984) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 's-wt1A-a'))))) OR (((`item_id3` = 84984) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 's-wt1A-a')))))) 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` = 84984 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93189) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G10'))))) OR (((`item_id2` = 93189) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G10'))))) OR (((`item_id3` = 93189) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G10')))))) 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` = 93189 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83844) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0990-006'))))) OR (((`item_id2` = 83844) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0990-006'))))) OR (((`item_id3` = 83844) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0990-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` = 83844 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79229) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G11'))))) OR (((`item_id2` = 79229) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G11'))))) OR (((`item_id3` = 79229) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G11')))))) 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` = 79229 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` = 98549) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-011'))))) OR (((`item_id2` = 98549) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-011'))))) OR (((`item_id3` = 98549) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-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` = 98549 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98548) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-009'))))) OR (((`item_id2` = 98548) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-009'))))) OR (((`item_id3` = 98548) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-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` = 98548 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-006'))))) OR (((`item_id2` = 98547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-006'))))) OR (((`item_id3` = 98547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-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` = 98547 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` = 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 `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98544) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-011'))))) OR (((`item_id2` = 98544) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-011'))))) OR (((`item_id3` = 98544) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-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` = 98544 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98543) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-009'))))) OR (((`item_id2` = 98543) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-009'))))) OR (((`item_id3` = 98543) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-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` = 98543 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98542) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-006'))))) OR (((`item_id2` = 98542) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-006'))))) OR (((`item_id3` = 98542) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-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` = 98542 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98541) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0019-045'))))) OR (((`item_id2` = 98541) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0019-045'))))) OR (((`item_id3` = 98541) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0019-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` = 98541 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98556) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0022-045'))))) OR (((`item_id2` = 98556) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0022-045'))))) OR (((`item_id3` = 98556) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0022-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` = 98556 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 | |