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 '%薬用%') 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 | 683 | 683 | 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 `Campaign`.`id` IS NOT NULL AND `Item`.`id` IN (6176, 6177, 6272, 6272, 6273, 6273, 6274, 6274, 29179, 29192, 29196, 29241, 36770, 45144, 45144, 54029, 54030, 54069, 64430, 64446, 64446, 64547, 64547, 71928, 73557, 74427, 74428, 74445, 74445, 74753, 74753, 74753, 74754, 74754, 74754, 74779, 74780, 74782, 74782, 75431, 75432, 75433, 75434, 75438, 76813, 76930, 76937, 77270, 77271, 77315, 77316, 77319, 78017, 78018, 78019, 78053, 78054, 78058, 78065, 78066, 78067, 78084, 78085, 79239, 79239, 81146, 81150, 81150, 81177, 81721, 83109, 83726, 83938, 83938, 83942, 83975, 83976, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84100, 84106, 84130, 84135, 84140, 84144, 84149, 84151, 84155, 84245, 84257, 84906, 84907, 84908, 85275, 85276, 85277, 85288, 85290, 85342, 85398, 85414, 85437, 85809, 85811, 86010, 86023, 86047, 86048, 86049, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 87275, 87278, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87653, 87654, 87662, 87664, 87665, 87775, 87776, 87777, 87778, 87783, 87784, 87785, 87786, 87925, 87935, 88141, 88142, 88143, 88144, 88173, 88278, 88279, 88280, 88283, 88283, 88526, 88530, 89467, 89467, 90102, 90103, 90104, 90122, 90123, 90124, 90321, 90322, 90326, 90326, 90332, 90357, 90460, 90467, 90468, 90469, 90470, 91029, 91030, 91031, 91032, 91033, 91034, 91050, 91051, 91052, 91053, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91320, 91321, 91322, 91322, 91323, 91327, 91327, 91328, 91328, 91329, 91335, 91336, 91347, 91367, 91371, 91373, 91375, 91484, 91485, 91506, 91507, 91507, 91508, 91509, 91509, 91516, 91557, 91560, 91567, 91568, 91570, 91570, 91582, 91585, 91727, 91728, 91739, 91739, 92065, 92076, 92333, 92334, 93123, 93130, 93136, 93171, 93592, 93594, 93956, 93956, 93972, 93977, 93978, 93979, 93982, 93984, 94033, 94036, 94037, 94253, 94253, 94254, 94254, 94269, 94270, 94272, 94273, 94274, 94275, 94276, 94277, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94339, 94350, 94362, 94363, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94743, 94745, 94746, 94747, 94754, 94760, 94762, 94763, 94764, 94765, 94766, 94767, 94769, 94772, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94812, 95073, 95083, 95084, 95087, 95088, 95088, 95089, 95095, 95095, 95096, 95099, 95100, 95109, 95111, 95113, 95120, 95121, 95158, 95340, 95341, 95342, 95343, 95344, 95345, 95346, 95361, 95362, 95363, 95364, 95364, 95365, 95365, 95366, 95367, 95368, 95369, 95369, 95372, 95376, 95377, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95411, 95412, 95413, 95414, 95415, 95416, 95417, 95418, 95419, 95420, 95604, 95605, 95606, 95607, 95608, 95654, 95655, 95656, 95657, 95658, 95659, 95660, 95661, 95744, 95878, 95884, 95885, 95886, 95887, 95888, 96039, 96040, 96041, 96042, 96043, 96045, 96046, 96047, 96048, 96050, 96051, 96058, 96060, 96061, 96064, 96121, 96122, 96346, 96349, 96361, 96362, 96426, 96570, 96579, 96691, 96693, 96695, 96697, 96701, 96703, 96747, 96757, 96761, 96813, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97033, 97035, 97036, 97037, 97039, 97041, 97042, 97044, 97048, 97049, 97052, 97053, 97055, 97057, 97058, 97203, 97204, 97205, 97217, 97218, 97219, 97283, 97332, 97333, 97365, 97367, 97367, 97370, 97370, 97375, 97376, 97380, 97381, 97383, 97383, 97386, 97387, 97390, 97391, 97392, 97394, 97395, 97396, 97426, 97428, 97605, 97606, 97617, 97618, 97618, 97619, 97619, 97620, 97621, 97622, 97623, 97624, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97665, 97666, 97667, 97674, 97716, 97716, 97717, 97717, 97718, 97718, 97784, 97785, 97786, 97787, 97788, 97789, 97790, 97791, 97799, 97800, 97801, 97805, 97811, 97814, 97816, 97817, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97833, 97834, 97837, 97838, 97839, 98108, 98109, 98161, 98180, 98442, 98442, 98443, 98443, 98445, 98446, 98447, 98448, 98449, 98450, 98451, 98452, 98454, 98456, 98457, 98458, 98467, 98468, 98469, 98470, 98471, 98472, 98474, 98475, 98480, 98481, 98482, 98483, 98484, 98485, 98489, 98677, 98688, 98689, 98785, 98803, 98804, 98820, 99039, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99106, 99107, 99108, 99115, 99116, 99117, 99118, 99119, 99125, 99126, 99127, 99130, 99137, 99138, 99163, 99212, 99213, 99214, 99318, 99320, 99326, 99507, 99628, 99734, 99741, 99752, 99753, 99754) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` 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 `Campaign`.`id` IS NOT NULL AND `Item`.`id` IN (6176, 6177, 6272, 6272, 6273, 6273, 6274, 6274, 29179, 29192, 29196, 29241, 36770, 45144, 45144, 54029, 54030, 54069, 64430, 64446, 64446, 64547, 64547, 71928, 73557, 74427, 74428, 74445, 74445, 74753, 74753, 74753, 74754, 74754, 74754, 74779, 74780, 74782, 74782, 75431, 75432, 75433, 75434, 75438, 76813, 76930, 76937, 77270, 77271, 77315, 77316, 77319, 78017, 78018, 78019, 78053, 78054, 78058, 78065, 78066, 78067, 78084, 78085, 79239, 79239, 81146, 81150, 81150, 81177, 81721, 83109, 83726, 83938, 83938, 83942, 83975, 83976, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84100, 84106, 84130, 84135, 84140, 84144, 84149, 84151, 84155, 84245, 84257, 84906, 84907, 84908, 85275, 85276, 85277, 85288, 85290, 85342, 85398, 85414, 85437, 85809, 85811, 86010, 86023, 86047, 86048, 86049, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 87275, 87278, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87653, 87654, 87662, 87664, 87665, 87775, 87776, 87777, 87778, 87783, 87784, 87785, 87786, 87925, 87935, 88141, 88142, 88143, 88144, 88173, 88278, 88279, 88280, 88283, 88283, 88526, 88530, 89467, 89467, 90102, 90103, 90104, 90122, 90123, 90124, 90321, 90322, 90326, 90326, 90332, 90357, 90460, 90467, 90468, 90469, 90470, 91029, 91030, 91031, 91032, 91033, 91034, 91050, 91051, 91052, 91053, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91320, 91321, 91322, 91322, 91323, 91327, 91327, 91328, 91328, 91329, 91335, 91336, 91347, 91367, 91371, 91373, 91375, 91484, 91485, 91506, 91507, 91507, 91508, 91509, 91509, 91516, 91557, 91560, 91567, 91568, 91570, 91570, 91582, 91585, 91727, 91728, 91739, 91739, 92065, 92076, 92333, 92334, 93123, 93130, 93136, 93171, 93592, 93594, 93956, 93956, 93972, 93977, 93978, 93979, 93982, 93984, 94033, 94036, 94037, 94253, 94253, 94254, 94254, 94269, 94270, 94272, 94273, 94274, 94275, 94276, 94277, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94339, 94350, 94362, 94363, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94743, 94745, 94746, 94747, 94754, 94760, 94762, 94763, 94764, 94765, 94766, 94767, 94769, 94772, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94812, 95073, 95083, 95084, 95087, 95088, 95088, 95089, 95095, 95095, 95096, 95099, 95100, 95109, 95111, 95113, 95120, 95121, 95158, 95340, 95341, 95342, 95343, 95344, 95345, 95346, 95361, 95362, 95363, 95364, 95364, 95365, 95365, 95366, 95367, 95368, 95369, 95369, 95372, 95376, 95377, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95411, 95412, 95413, 95414, 95415, 95416, 95417, 95418, 95419, 95420, 95604, 95605, 95606, 95607, 95608, 95654, 95655, 95656, 95657, 95658, 95659, 95660, 95661, 95744, 95878, 95884, 95885, 95886, 95887, 95888, 96039, 96040, 96041, 96042, 96043, 96045, 96046, 96047, 96048, 96050, 96051, 96058, 96060, 96061, 96064, 96121, 96122, 96346, 96349, 96361, 96362, 96426, 96570, 96579, 96691, 96693, 96695, 96697, 96701, 96703, 96747, 96757, 96761, 96813, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97033, 97035, 97036, 97037, 97039, 97041, 97042, 97044, 97048, 97049, 97052, 97053, 97055, 97057, 97058, 97203, 97204, 97205, 97217, 97218, 97219, 97283, 97332, 97333, 97365, 97367, 97367, 97370, 97370, 97375, 97376, 97380, 97381, 97383, 97383, 97386, 97387, 97390, 97391, 97392, 97394, 97395, 97396, 97426, 97428, 97605, 97606, 97617, 97618, 97618, 97619, 97619, 97620, 97621, 97622, 97623, 97624, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97665, 97666, 97667, 97674, 97716, 97716, 97717, 97717, 97718, 97718, 97784, 97785, 97786, 97787, 97788, 97789, 97790, 97791, 97799, 97800, 97801, 97805, 97811, 97814, 97816, 97817, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97833, 97834, 97837, 97838, 97839, 98108, 98109, 98161, 98180, 98442, 98442, 98443, 98443, 98445, 98446, 98447, 98448, 98449, 98450, 98451, 98452, 98454, 98456, 98457, 98458, 98467, 98468, 98469, 98470, 98471, 98472, 98474, 98475, 98480, 98481, 98482, 98483, 98484, 98485, 98489, 98677, 98688, 98689, 98785, 98803, 98804, 98820, 99039, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99106, 99107, 99108, 99115, 99116, 99117, 99118, 99119, 99125, 99126, 99127, 99130, 99137, 99138, 99163, 99212, 99213, 99214, 99318, 99320, 99326, 99507, 99628, 99734, 99741, 99752, 99753, 99754) AND `item_rank` <> 3 | 1 | 1 | 2 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83942) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708561'))))) OR (((`item_id2` = 83942) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708561'))))) OR (((`item_id3` = 83942) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708561')))))) 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` = 83942 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90460) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708721'))))) OR (((`item_id2` = 90460) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708721'))))) OR (((`item_id3` = 90460) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708721')))))) 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` = 90460 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91052) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372731'))))) OR (((`item_id2` = 91052) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372731'))))) OR (((`item_id3` = 91052) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372731')))))) 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` = 91052 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83975) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-226946'))))) OR (((`item_id2` = 83975) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-226946'))))) OR (((`item_id3` = 83975) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-226946')))))) 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` = 83975 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95377) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325110'))))) OR (((`item_id2` = 95377) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325110'))))) OR (((`item_id3` = 95377) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325110')))))) 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` = 95377 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78085) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-191046'))))) OR (((`item_id2` = 78085) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-191046'))))) OR (((`item_id3` = 78085) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-191046')))))) 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` = 78085 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88141) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-280948'))))) OR (((`item_id2` = 88141) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-280948'))))) OR (((`item_id3` = 88141) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-280948')))))) 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` = 88141 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95368) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846121'))))) OR (((`item_id2` = 95368) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846121'))))) OR (((`item_id3` = 95368) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846121')))))) 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` = 95368 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85342) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-242441'))))) OR (((`item_id2` = 85342) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-242441'))))) OR (((`item_id3` = 85342) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-242441')))))) 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` = 85342 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77319) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-180347'))))) OR (((`item_id2` = 77319) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-180347'))))) OR (((`item_id3` = 77319) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-180347')))))) 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` = 77319 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54030) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-97447'))))) OR (((`item_id2` = 54030) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-97447'))))) OR (((`item_id3` = 54030) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-97447')))))) 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` = 54030 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95655) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1894-044'))))) OR (((`item_id2` = 95655) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1894-044'))))) OR (((`item_id3` = 95655) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1894-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` = 95655 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97790) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374981'))))) OR (((`item_id2` = 97790) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374981'))))) OR (((`item_id3` = 97790) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374981')))))) 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` = 97790 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97801) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374801'))))) OR (((`item_id2` = 97801) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374801'))))) OR (((`item_id3` = 97801) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374801')))))) 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` = 97801 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97786) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374831'))))) OR (((`item_id2` = 97786) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374831'))))) OR (((`item_id3` = 97786) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374831')))))) 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` = 97786 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 | |