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 '%ステンレスタンブラー%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 414 | 414 | 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`.`id` IN (35665, 45518, 45518, 45539, 45539, 54029, 54030, 57708, 57709, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 64676, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 65358, 65366, 65373, 65374, 77072, 77073, 77074, 77215, 77216, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 79023, 79023, 80717, 80717, 80718, 80718, 80719, 80720, 81146, 81477, 81478, 81479, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 83752, 84484, 84485, 84486, 84487, 84489, 84490, 84491, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84608, 84609, 84610, 84611, 85019, 85020, 85021, 85022, 85023, 85024, 85117, 85118, 85119, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85212, 85213, 85275, 85276, 85277, 85333, 85404, 85644, 85645, 86072, 86074, 86075, 86110, 87291, 87291, 87319, 87320, 87321, 87322, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 88278, 88279, 88280, 88861, 88862, 88863, 88864, 90370, 90371, 90695, 90696, 90697, 90698, 90715, 90716, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91327, 91327, 91425, 91426, 91427, 91428, 91429, 91745, 92356, 92359, 93941, 94353, 94381, 94382, 94383, 94384, 94385, 94386, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94497, 94498, 94498, 94499, 94500, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94746, 94747, 94799, 94800, 94801, 94821, 94839, 94840, 94841, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95130, 95131, 95132, 95133, 95134, 95180, 95207, 95208, 95209, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95346, 95357, 95417, 95518, 95519, 95520, 95521, 95569, 95570, 95571, 95572, 95573, 95662, 95663, 95664, 95665, 95666, 95667, 95672, 95673, 95674, 95675, 95762, 95777, 96568, 96569, 96807, 97727, 97727, 97868, 97869, 97870, 97871, 97888, 97889, 97890, 97897, 97898, 97899, 97918, 97919, 97920, 97921, 97922, 97997, 97998, 97999, 98000, 98001, 98002, 98079, 98080, 98081, 98082, 98083, 98084, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98573, 98574, 98575, 98576, 98612, 98613, 98614, 98615, 98616, 98617, 98688, 98689, 98790, 99018, 99019, 99020, 99388, 99389, 99390) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` desc LIMIT 15 | 15 | 15 | 4 | 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 (35665, 45518, 45518, 45539, 45539, 54029, 54030, 57708, 57709, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 64676, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 65358, 65366, 65373, 65374, 77072, 77073, 77074, 77215, 77216, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 79023, 79023, 80717, 80717, 80718, 80718, 80719, 80720, 81146, 81477, 81478, 81479, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 83752, 84484, 84485, 84486, 84487, 84489, 84490, 84491, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84608, 84609, 84610, 84611, 85019, 85020, 85021, 85022, 85023, 85024, 85117, 85118, 85119, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85212, 85213, 85275, 85276, 85277, 85333, 85404, 85644, 85645, 86072, 86074, 86075, 86110, 87291, 87291, 87319, 87320, 87321, 87322, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 88278, 88279, 88280, 88861, 88862, 88863, 88864, 90370, 90371, 90695, 90696, 90697, 90698, 90715, 90716, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91327, 91327, 91425, 91426, 91427, 91428, 91429, 91745, 92356, 92359, 93941, 94353, 94381, 94382, 94383, 94384, 94385, 94386, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94497, 94498, 94498, 94499, 94500, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94746, 94747, 94799, 94800, 94801, 94821, 94839, 94840, 94841, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95130, 95131, 95132, 95133, 95134, 95180, 95207, 95208, 95209, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95346, 95357, 95417, 95518, 95519, 95520, 95521, 95569, 95570, 95571, 95572, 95573, 95662, 95663, 95664, 95665, 95666, 95667, 95672, 95673, 95674, 95675, 95762, 95777, 96568, 96569, 96807, 97727, 97727, 97868, 97869, 97870, 97871, 97888, 97889, 97890, 97897, 97898, 97899, 97918, 97919, 97920, 97921, 97922, 97997, 97998, 97999, 98000, 98001, 98002, 98079, 98080, 98081, 98082, 98083, 98084, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98573, 98574, 98575, 98576, 98612, 98613, 98614, 98615, 98616, 98617, 98688, 98689, 98790, 99018, 99019, 99020, 99388, 99389, 99390) AND `item_rank` <> 3 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98688) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25239G7'))))) OR (((`item_id2` = 98688) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25239G7'))))) OR (((`item_id3` = 98688) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25239G7')))))) 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` = 98688 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98689) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25239G8'))))) OR (((`item_id2` = 98689) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25239G8'))))) OR (((`item_id3` = 98689) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25239G8')))))) 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` = 98689 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92356) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G2'))))) OR (((`item_id2` = 92356) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G2'))))) OR (((`item_id3` = 92356) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G2')))))) 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` = 92356 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92359) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G7'))))) OR (((`item_id2` = 92359) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G7'))))) OR (((`item_id3` = 92359) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G7')))))) 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` = 92359 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91327) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2323860'))))) OR (((`item_id2` = 91327) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2323860'))))) OR (((`item_id3` = 91327) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2323860')))))) 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` = 91327 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88861) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2579G3A'))))) OR (((`item_id2` = 88861) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2579G3A'))))) OR (((`item_id3` = 88861) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2579G3A')))))) 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` = 88861 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88862) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2579G3B'))))) OR (((`item_id2` = 88862) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2579G3B'))))) OR (((`item_id3` = 88862) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2579G3B')))))) 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` = 88862 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88863) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2579G3C'))))) OR (((`item_id2` = 88863) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2579G3C'))))) OR (((`item_id3` = 88863) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2579G3C')))))) 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` = 88863 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88864) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2579G3D'))))) OR (((`item_id2` = 88864) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2579G3D'))))) OR (((`item_id3` = 88864) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2579G3D')))))) 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` = 88864 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77072) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-36780A'))))) OR (((`item_id2` = 77072) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-36780A'))))) OR (((`item_id3` = 77072) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-36780A')))))) 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` = 77072 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77073) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-36780B'))))) OR (((`item_id2` = 77073) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-36780B'))))) OR (((`item_id3` = 77073) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-36780B')))))) 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` = 77073 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77074) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-36780C'))))) OR (((`item_id2` = 77074) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-36780C'))))) OR (((`item_id3` = 77074) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-36780C')))))) 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` = 77074 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85275) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-247941'))))) OR (((`item_id2` = 85275) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-247941'))))) OR (((`item_id3` = 85275) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-247941')))))) 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` = 85275 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85276) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-248047'))))) OR (((`item_id2` = 85276) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-248047'))))) OR (((`item_id3` = 85276) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-248047')))))) 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` = 85276 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85277) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-248146'))))) OR (((`item_id2` = 85277) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-248146'))))) OR (((`item_id3` = 85277) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-248146')))))) 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` = 85277 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 | |