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 | 379 | 379 | 416 | 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 (6514, 6514, 35169, 35328, 44175, 44175, 45522, 58154, 58156, 58156, 58157, 58158, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 65373, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77712, 81611, 83885, 83886, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 84165, 84174, 84177, 84178, 84179, 84313, 84313, 84314, 84314, 84315, 84315, 84612, 84613, 84616, 84618, 84620, 84622, 85333, 87347, 87348, 87349, 87350, 87351, 88240, 88241, 88242, 88243, 88244, 88245, 91057, 91070, 91070, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91483, 91859, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 92277, 92278, 92279, 94361, 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, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94706, 94754, 94827, 94827, 95123, 95124, 95125, 95126, 95127, 95169, 95205, 95206, 95207, 95208, 95209, 95225, 95226, 95227, 95228, 95229, 95230, 95235, 95236, 95247, 95248, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95421, 95422, 95423, 95662, 95663, 95664, 95665, 95666, 95667, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95746, 95766, 95767, 96381, 97326, 97688, 97689, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97872, 97873, 97874, 97875, 97888, 97889, 97890, 97897, 97898, 97899, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98166, 98173, 98173, 98412, 98629, 98640, 98641, 98691, 98692, 98949, 98950, 99305, 99306, 99307, 99308, 99309, 99310, 99311, 99406, 99407, 99408, 99409, 99410, 99428, 99513, 99515, 99517, 99518, 99519, 99520, 99521, 99522, 99523) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 2 | 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 (6514, 6514, 35169, 35328, 44175, 44175, 45522, 58154, 58156, 58156, 58157, 58158, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 65373, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77712, 81611, 83885, 83886, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 84165, 84174, 84177, 84178, 84179, 84313, 84313, 84314, 84314, 84315, 84315, 84612, 84613, 84616, 84618, 84620, 84622, 85333, 87347, 87348, 87349, 87350, 87351, 88240, 88241, 88242, 88243, 88244, 88245, 91057, 91070, 91070, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91483, 91859, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 92277, 92278, 92279, 94361, 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, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94706, 94754, 94827, 94827, 95123, 95124, 95125, 95126, 95127, 95169, 95205, 95206, 95207, 95208, 95209, 95225, 95226, 95227, 95228, 95229, 95230, 95235, 95236, 95247, 95248, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95421, 95422, 95423, 95662, 95663, 95664, 95665, 95666, 95667, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95746, 95766, 95767, 96381, 97326, 97688, 97689, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97872, 97873, 97874, 97875, 97888, 97889, 97890, 97897, 97898, 97899, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98166, 98173, 98173, 98412, 98629, 98640, 98641, 98691, 98692, 98949, 98950, 99305, 99306, 99307, 99308, 99309, 99310, 99311, 99406, 99407, 99408, 99409, 99410, 99428, 99513, 99515, 99517, 99518, 99519, 99520, 99521, 99522, 99523) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35169) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-008'))))) OR (((`item_id2` = 35169) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-008'))))) OR (((`item_id3` = 35169) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-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` = 35169 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0733NB'))))) OR (((`item_id2` = 74333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0733NB'))))) OR (((`item_id3` = 74333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0733NB')))))) 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` = 74333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-002'))))) OR (((`item_id2` = 77246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-002'))))) OR (((`item_id3` = 77246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-002')))))) 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` = 77246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84313) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-238444'))))) OR (((`item_id2` = 84313) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-238444'))))) OR (((`item_id3` = 84313) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-238444')))))) 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` = 84313 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91878) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G6F'))))) OR (((`item_id2` = 91878) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G6F'))))) OR (((`item_id3` = 91878) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G6F')))))) 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` = 91878 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74334) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0733ND'))))) OR (((`item_id2` = 74334) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0733ND'))))) OR (((`item_id3` = 74334) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0733ND')))))) 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` = 74334 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97858) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1337-006'))))) OR (((`item_id2` = 97858) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1337-006'))))) OR (((`item_id3` = 97858) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1337-006')))))) 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` = 97858 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95225) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1296-008'))))) OR (((`item_id2` = 95225) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1296-008'))))) OR (((`item_id3` = 95225) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1296-008')))))) 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` = 95225 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97975) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0436-045'))))) OR (((`item_id2` = 97975) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0436-045'))))) OR (((`item_id3` = 97975) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0436-045')))))) 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` = 97975 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91070) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372681'))))) OR (((`item_id2` = 91070) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372681'))))) OR (((`item_id3` = 91070) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372681')))))) 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` = 91070 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6514) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-441G12A'))))) OR (((`item_id2` = 6514) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-441G12A'))))) OR (((`item_id3` = 6514) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-441G12A')))))) 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` = 6514 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95292) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-034'))))) OR (((`item_id2` = 95292) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-034'))))) OR (((`item_id3` = 95292) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-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` = 95292 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91877) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G6E'))))) OR (((`item_id2` = 91877) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G6E'))))) OR (((`item_id3` = 91877) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G6E')))))) 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` = 91877 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98412) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36225'))))) OR (((`item_id2` = 98412) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36225'))))) OR (((`item_id3` = 98412) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36225')))))) 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` = 98412 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91874) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G6B'))))) OR (((`item_id2` = 91874) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G6B'))))) OR (((`item_id3` = 91874) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G6B')))))) 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` = 91874 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |