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 '%BBQ%') OR (`Item`.`item_name` Like '%BBQ%') OR (`Item`.`item_figure` Like '%BBQ%') OR (`Item`.`item_color` Like '%BBQ%') OR (`Item`.`item_materials` Like '%BBQ%') OR (`Item`.`item_note` Like '%BBQ%') 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 '%オーブングリル%') 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 | 735 | 735 | 531 | 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, 64479, 64481, 64542, 64622, 64630, 64630, 64631, 64631, 64686, 65204, 69675, 69846, 71525, 71526, 73614, 73864, 73864, 73866, 76118, 77075, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 78142, 79023, 79023, 79302, 80646, 80646, 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, 87448, 87760, 87775, 87776, 87777, 87778, 87856, 87856, 87857, 87890, 87891, 87913, 87913, 87913, 87914, 87914, 87914, 88150, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88201, 88202, 88203, 88594, 88595, 89932, 89933, 90026, 90027, 90102, 90103, 90104, 90325, 90326, 90326, 90414, 90414, 90415, 90415, 90435, 90437, 90439, 90449, 90450, 90462, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90686, 90687, 90690, 90690, 90691, 90692, 90693, 90694, 90720, 90721, 90731, 90732, 90735, 90736, 90738, 90739, 90743, 90744, 90769, 90770, 90773, 90774, 90777, 90778, 90781, 90782, 90785, 90786, 90789, 90790, 90793, 90794, 90797, 90798, 90801, 90802, 90805, 90806, 90809, 90810, 90813, 90814, 90859, 90860, 90863, 90864, 90867, 90868, 90871, 90872, 90875, 90876, 90879, 90880, 90883, 90884, 90887, 90888, 90892, 90893, 90896, 90897, 90900, 90901, 90904, 90905, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90950, 90951, 90952, 90957, 90958, 90969, 90970, 90975, 90976, 90980, 90981, 90985, 90986, 90990, 90991, 90992, 90993, 90994, 90995, 90999, 91000, 91025, 91026, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91133, 91134, 91323, 91387, 91403, 91408, 91412, 91416, 91421, 91426, 91431, 91436, 91488, 91662, 91663, 91670, 91719, 91720, 91754, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92389, 92390, 92391, 92395, 92396, 92397, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92833, 92880, 92890, 93193, 93265, 93319, 93453, 93454, 93631, 93636, 93735, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93949, 93955, 94339, 94342, 94342, 94359, 94380, 94380, 94386, 94390, 94395, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94455, 94456, 94457, 94458, 94461, 94465, 94466, 94470, 94471, 94475, 94476, 94480, 94481, 94485, 94486, 94490, 94491, 94519, 94521, 94546, 94547, 94560, 94561, 94562, 94565, 94568, 94643, 94645, 94648, 94650, 94660, 94662, 94664, 94671, 94672, 94675, 94678, 94679, 94681, 94682, 94684, 94685, 94687, 94688, 94690, 94691, 94692, 94693, 94702, 94721, 94722, 94723, 94724, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94830, 94830, 94847, 94848, 94849, 95132, 95133, 95156, 95185, 95192, 95192, 95197, 95202, 95257, 95260, 95263, 95266, 95273, 95278, 95283, 95289, 95290, 95291, 95292, 95306, 95328, 95329, 95333, 95334, 95346, 95355, 95356, 95361, 95376, 95408, 95424, 95441, 95445, 95449, 95453, 95457, 95509, 95541, 95542, 95546, 95547, 95555, 95557, 95570, 95589, 95593, 95624, 95625, 95660, 95671, 95675, 95759, 95767, 95772, 95774, 95774, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 96139, 96140, 96141, 96146, 96147, 96211, 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, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 96744, 96860, 96861, 96862, 96929, 96932, 96933, 96935, 96938, 97045, 97050, 97089, 97362, 97368, 97368, 97369, 97376, 97674, 97732, 97733, 97739, 97740, 97746, 97747, 97753, 97754, 97760, 97761, 97767, 97768, 97774, 97775, 97781, 97782, 97796, 97876, 97877, 97878, 97879, 97880, 97881, 97900, 97901, 97902, 97903, 97905, 97924, 97924, 97925, 97925, 97929, 97930, 97936, 97937, 97941, 97942, 97945, 97945, 97946, 97946, 97950, 97951, 97955, 97956, 98024, 98026, 98032, 98034, 98037, 98041, 98118, 98118, 98121, 98122, 98123, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98167, 98169, 98169, 98172, 98172, 98179, 98424, 98434, 98437, 98437, 98500, 98505, 98611, 98614, 98617, 98620, 98622, 98623, 98624, 98625, 98642, 98643, 98644, 98645, 98646, 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, 99006, 99166, 99198, 99215, 99216, 99217, 99267, 99268, 99285, 99297, 99364, 99365, 99383, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426, 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`.`item_price` desc LIMIT 15 | 15 | 15 | 6 | 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, 64479, 64481, 64542, 64622, 64630, 64630, 64631, 64631, 64686, 65204, 69675, 69846, 71525, 71526, 73614, 73864, 73864, 73866, 76118, 77075, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 78142, 79023, 79023, 79302, 80646, 80646, 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, 87448, 87760, 87775, 87776, 87777, 87778, 87856, 87856, 87857, 87890, 87891, 87913, 87913, 87913, 87914, 87914, 87914, 88150, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88201, 88202, 88203, 88594, 88595, 89932, 89933, 90026, 90027, 90102, 90103, 90104, 90325, 90326, 90326, 90414, 90414, 90415, 90415, 90435, 90437, 90439, 90449, 90450, 90462, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90686, 90687, 90690, 90690, 90691, 90692, 90693, 90694, 90720, 90721, 90731, 90732, 90735, 90736, 90738, 90739, 90743, 90744, 90769, 90770, 90773, 90774, 90777, 90778, 90781, 90782, 90785, 90786, 90789, 90790, 90793, 90794, 90797, 90798, 90801, 90802, 90805, 90806, 90809, 90810, 90813, 90814, 90859, 90860, 90863, 90864, 90867, 90868, 90871, 90872, 90875, 90876, 90879, 90880, 90883, 90884, 90887, 90888, 90892, 90893, 90896, 90897, 90900, 90901, 90904, 90905, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90950, 90951, 90952, 90957, 90958, 90969, 90970, 90975, 90976, 90980, 90981, 90985, 90986, 90990, 90991, 90992, 90993, 90994, 90995, 90999, 91000, 91025, 91026, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91133, 91134, 91323, 91387, 91403, 91408, 91412, 91416, 91421, 91426, 91431, 91436, 91488, 91662, 91663, 91670, 91719, 91720, 91754, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92389, 92390, 92391, 92395, 92396, 92397, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92833, 92880, 92890, 93193, 93265, 93319, 93453, 93454, 93631, 93636, 93735, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93949, 93955, 94339, 94342, 94342, 94359, 94380, 94380, 94386, 94390, 94395, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94455, 94456, 94457, 94458, 94461, 94465, 94466, 94470, 94471, 94475, 94476, 94480, 94481, 94485, 94486, 94490, 94491, 94519, 94521, 94546, 94547, 94560, 94561, 94562, 94565, 94568, 94643, 94645, 94648, 94650, 94660, 94662, 94664, 94671, 94672, 94675, 94678, 94679, 94681, 94682, 94684, 94685, 94687, 94688, 94690, 94691, 94692, 94693, 94702, 94721, 94722, 94723, 94724, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94830, 94830, 94847, 94848, 94849, 95132, 95133, 95156, 95185, 95192, 95192, 95197, 95202, 95257, 95260, 95263, 95266, 95273, 95278, 95283, 95289, 95290, 95291, 95292, 95306, 95328, 95329, 95333, 95334, 95346, 95355, 95356, 95361, 95376, 95408, 95424, 95441, 95445, 95449, 95453, 95457, 95509, 95541, 95542, 95546, 95547, 95555, 95557, 95570, 95589, 95593, 95624, 95625, 95660, 95671, 95675, 95759, 95767, 95772, 95774, 95774, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 96139, 96140, 96141, 96146, 96147, 96211, 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, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 96744, 96860, 96861, 96862, 96929, 96932, 96933, 96935, 96938, 97045, 97050, 97089, 97362, 97368, 97368, 97369, 97376, 97674, 97732, 97733, 97739, 97740, 97746, 97747, 97753, 97754, 97760, 97761, 97767, 97768, 97774, 97775, 97781, 97782, 97796, 97876, 97877, 97878, 97879, 97880, 97881, 97900, 97901, 97902, 97903, 97905, 97924, 97924, 97925, 97925, 97929, 97930, 97936, 97937, 97941, 97942, 97945, 97945, 97946, 97946, 97950, 97951, 97955, 97956, 98024, 98026, 98032, 98034, 98037, 98041, 98118, 98118, 98121, 98122, 98123, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98167, 98169, 98169, 98172, 98172, 98179, 98424, 98434, 98437, 98437, 98500, 98505, 98611, 98614, 98617, 98620, 98622, 98623, 98624, 98625, 98642, 98643, 98644, 98645, 98646, 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, 99006, 99166, 99198, 99215, 99216, 99217, 99267, 99268, 99285, 99297, 99364, 99365, 99383, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426, 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 | 4 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92641) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G1'))))) OR (((`item_id2` = 92641) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G1'))))) OR (((`item_id3` = 92641) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G1')))))) 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` = 92641 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96364) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25240G2'))))) OR (((`item_id2` = 96364) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25240G2'))))) OR (((`item_id3` = 96364) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25240G2')))))) 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` = 96364 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95939) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G5'))))) OR (((`item_id2` = 95939) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G5'))))) OR (((`item_id3` = 95939) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G5')))))) 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` = 95939 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96361) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25239G5'))))) OR (((`item_id2` = 96361) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25239G5'))))) OR (((`item_id3` = 96361) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25239G5')))))) 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` = 96361 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99568) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2563G4'))))) OR (((`item_id2` = 99568) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2563G4'))))) OR (((`item_id3` = 99568) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2563G4')))))) 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` = 99568 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98885) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2564G1A'))))) OR (((`item_id2` = 98885) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2564G1A'))))) OR (((`item_id3` = 98885) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2564G1A')))))) 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` = 98885 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98886) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2564G1B'))))) OR (((`item_id2` = 98886) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2564G1B'))))) OR (((`item_id3` = 98886) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2564G1B')))))) 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` = 98886 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92619) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2593G6'))))) OR (((`item_id2` = 92619) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2593G6'))))) OR (((`item_id3` = 92619) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2593G6')))))) 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` = 92619 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92646) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2594G1'))))) OR (((`item_id2` = 92646) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2594G1'))))) OR (((`item_id3` = 92646) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2594G1')))))) 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` = 92646 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96660) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2594G2'))))) OR (((`item_id2` = 96660) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2594G2'))))) OR (((`item_id3` = 96660) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2594G2')))))) 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` = 96660 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95940) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2594G3'))))) OR (((`item_id2` = 95940) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2594G3'))))) OR (((`item_id3` = 95940) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2594G3')))))) 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` = 95940 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99569) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2563G5'))))) OR (((`item_id2` = 99569) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2563G5'))))) OR (((`item_id3` = 99569) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2563G5')))))) 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` = 99569 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99570) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2563G6'))))) OR (((`item_id2` = 99570) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2563G6'))))) OR (((`item_id3` = 99570) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2563G6')))))) 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` = 99570 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96661) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2595G8'))))) OR (((`item_id2` = 96661) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2595G8'))))) OR (((`item_id3` = 96661) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2595G8')))))) 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` = 96661 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25239G6'))))) OR (((`item_id2` = 96362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25239G6'))))) OR (((`item_id3` = 96362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25239G6')))))) 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` = 96362 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 | 1 | |