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 | 392 | 392 | 396 | 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 (54083, 54083, 54085, 54085, 54086, 54086, 64481, 64542, 64622, 64630, 64630, 64631, 64631, 64686, 65204, 71525, 71526, 73614, 73864, 73864, 73866, 76118, 77075, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 78142, 79023, 79023, 79302, 81547, 81548, 81549, 81550, 81551, 81721, 83796, 83796, 83861, 83862, 83863, 83864, 84468, 84469, 84583, 85039, 85039, 85040, 85040, 85041, 85041, 85062, 85063, 85066, 85067, 85068, 85455, 86033, 86034, 86035, 86036, 86037, 86097, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87760, 87775, 87776, 87777, 87778, 87856, 87856, 87857, 87913, 87913, 87913, 87914, 87914, 87914, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88201, 88202, 88203, 88594, 88595, 89932, 89933, 90026, 90027, 90102, 90103, 90104, 90414, 90414, 90415, 90415, 90449, 90678, 90679, 90680, 90681, 90691, 90692, 90693, 90694, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90950, 90951, 90952, 91037, 91122, 91133, 91134, 91323, 91387, 91488, 91719, 91720, 91754, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92389, 92390, 92391, 92395, 92396, 92397, 92615, 92833, 92880, 92890, 93193, 93265, 93319, 93453, 93454, 93735, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93949, 93955, 94339, 94342, 94342, 94359, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94455, 94456, 94457, 94458, 94546, 94547, 94560, 94561, 94562, 94721, 94722, 94723, 94724, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94830, 94830, 94847, 94848, 94849, 95156, 95185, 95289, 95290, 95291, 95292, 95346, 95355, 95356, 95376, 95408, 95424, 95759, 95767, 95772, 95774, 95774, 95778, 95778, 95952, 96139, 96140, 96141, 96146, 96147, 96212, 96213, 96215, 96226, 96237, 96338, 96353, 96361, 96362, 96364, 96386, 96426, 96430, 96450, 96454, 96469, 96504, 96538, 96539, 96540, 96542, 96543, 96625, 96626, 96627, 96628, 96630, 96633, 96639, 96659, 96677, 96744, 96860, 96861, 96862, 96929, 96932, 96933, 96935, 96938, 97045, 97050, 97089, 97362, 97376, 97674, 97876, 97877, 97878, 97879, 97880, 97881, 97900, 97901, 97902, 98118, 98118, 98123, 98126, 98127, 98136, 98137, 98138, 98167, 98169, 98169, 98172, 98172, 98179, 98424, 98434, 98642, 98643, 98644, 98645, 98649, 98658, 98659, 98660, 98661, 98665, 98748, 98757, 98765, 98769, 98772, 98773, 98776, 98797, 98823, 98834, 98836, 98882, 98883, 98884, 98885, 98886, 98917, 98918, 98971, 98972, 98973, 99166, 99198, 99215, 99216, 99217, 99267, 99268, 99297, 99364, 99365, 99421, 99444, 99450, 99451, 99452, 99453, 99454, 99455, 99524, 99568, 99569, 99570, 99584, 99585, 99586, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99696, 99723) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 3 | 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 (54083, 54083, 54085, 54085, 54086, 54086, 64481, 64542, 64622, 64630, 64630, 64631, 64631, 64686, 65204, 71525, 71526, 73614, 73864, 73864, 73866, 76118, 77075, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 78142, 79023, 79023, 79302, 81547, 81548, 81549, 81550, 81551, 81721, 83796, 83796, 83861, 83862, 83863, 83864, 84468, 84469, 84583, 85039, 85039, 85040, 85040, 85041, 85041, 85062, 85063, 85066, 85067, 85068, 85455, 86033, 86034, 86035, 86036, 86037, 86097, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87760, 87775, 87776, 87777, 87778, 87856, 87856, 87857, 87913, 87913, 87913, 87914, 87914, 87914, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88201, 88202, 88203, 88594, 88595, 89932, 89933, 90026, 90027, 90102, 90103, 90104, 90414, 90414, 90415, 90415, 90449, 90678, 90679, 90680, 90681, 90691, 90692, 90693, 90694, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90950, 90951, 90952, 91037, 91122, 91133, 91134, 91323, 91387, 91488, 91719, 91720, 91754, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92389, 92390, 92391, 92395, 92396, 92397, 92615, 92833, 92880, 92890, 93193, 93265, 93319, 93453, 93454, 93735, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93949, 93955, 94339, 94342, 94342, 94359, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94455, 94456, 94457, 94458, 94546, 94547, 94560, 94561, 94562, 94721, 94722, 94723, 94724, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94830, 94830, 94847, 94848, 94849, 95156, 95185, 95289, 95290, 95291, 95292, 95346, 95355, 95356, 95376, 95408, 95424, 95759, 95767, 95772, 95774, 95774, 95778, 95778, 95952, 96139, 96140, 96141, 96146, 96147, 96212, 96213, 96215, 96226, 96237, 96338, 96353, 96361, 96362, 96364, 96386, 96426, 96430, 96450, 96454, 96469, 96504, 96538, 96539, 96540, 96542, 96543, 96625, 96626, 96627, 96628, 96630, 96633, 96639, 96659, 96677, 96744, 96860, 96861, 96862, 96929, 96932, 96933, 96935, 96938, 97045, 97050, 97089, 97362, 97376, 97674, 97876, 97877, 97878, 97879, 97880, 97881, 97900, 97901, 97902, 98118, 98118, 98123, 98126, 98127, 98136, 98137, 98138, 98167, 98169, 98169, 98172, 98172, 98179, 98424, 98434, 98642, 98643, 98644, 98645, 98649, 98658, 98659, 98660, 98661, 98665, 98748, 98757, 98765, 98769, 98772, 98773, 98776, 98797, 98823, 98834, 98836, 98882, 98883, 98884, 98885, 98886, 98917, 98918, 98971, 98972, 98973, 99166, 99198, 99215, 99216, 99217, 99267, 99268, 99297, 99364, 99365, 99421, 99444, 99450, 99451, 99452, 99453, 99454, 99455, 99524, 99568, 99569, 99570, 99584, 99585, 99586, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99696, 99723) AND `item_rank` <> 3 | 1 | 1 | 3 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79023) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G8'))))) OR (((`item_id2` = 79023) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G8'))))) OR (((`item_id3` = 79023) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G8')))))) 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` = 79023 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91941) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25312G7A'))))) OR (((`item_id2` = 91941) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25312G7A'))))) OR (((`item_id3` = 91941) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25312G7A')))))) 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` = 91941 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95774) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35859'))))) OR (((`item_id2` = 95774) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35859'))))) OR (((`item_id3` = 95774) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35859')))))) 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` = 95774 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | 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` = 77246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94546) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1816-009'))))) OR (((`item_id2` = 94546) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1816-009'))))) OR (((`item_id3` = 94546) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1816-009')))))) 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` = 94546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98167) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36108'))))) OR (((`item_id2` = 98167) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36108'))))) OR (((`item_id3` = 98167) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36108')))))) 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` = 98167 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95424) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TT-0001-044'))))) OR (((`item_id2` = 95424) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TT-0001-044'))))) OR (((`item_id3` = 95424) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TT-0001-044')))))) 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` = 95424 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 98424) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36218'))))) OR (((`item_id2` = 98424) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36218'))))) OR (((`item_id3` = 98424) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36218')))))) 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` = 98424 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98434) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36203'))))) OR (((`item_id2` = 98434) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36203'))))) OR (((`item_id3` = 98434) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36203')))))) 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` = 98434 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97089) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25214G1'))))) OR (((`item_id2` = 97089) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25214G1'))))) OR (((`item_id3` = 97089) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25214G1')))))) 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` = 97089 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96539) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25134G6B'))))) OR (((`item_id2` = 96539) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25134G6B'))))) OR (((`item_id3` = 96539) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25134G6B')))))) 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` = 96539 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96543) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25135G2B'))))) OR (((`item_id2` = 96543) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25135G2B'))))) OR (((`item_id3` = 96543) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25135G2B')))))) 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` = 96543 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81721) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-215247'))))) OR (((`item_id2` = 81721) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-215247'))))) OR (((`item_id3` = 81721) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-215247')))))) 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` = 81721 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98179) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36192'))))) OR (((`item_id2` = 98179) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36192'))))) OR (((`item_id3` = 98179) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36192')))))) 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` = 98179 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 | |