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 | 1774 | 1774 | 375 | 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 (6777, 6777, 6778, 6778, 6779, 6779, 12380, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34886, 34961, 34963, 34968, 34969, 34969, 34970, 34970, 34971, 34971, 34974, 34983, 35017, 35161, 35292, 35292, 35294, 35301, 35301, 35303, 35310, 35310, 35312, 35343, 35343, 35403, 35403, 35448, 35450, 35676, 35692, 35726, 35726, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35788, 35788, 38504, 38504, 44664, 44664, 44678, 44678, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44781, 44781, 44785, 44786, 44787, 44788, 45501, 45516, 45516, 45518, 45518, 45539, 45539, 54083, 54083, 54085, 54085, 54086, 54086, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58154, 58155, 58155, 58156, 58156, 58215, 58222, 58231, 58231, 58344, 58345, 58345, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64430, 64547, 64547, 64618, 64618, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64647, 64660, 64670, 64670, 64671, 64671, 64672, 64672, 65199, 65209, 65209, 65212, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65271, 65271, 65272, 65272, 65273, 65273, 65276, 65276, 65277, 65277, 65278, 65280, 65280, 65282, 65282, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65337, 65338, 65338, 65340, 65340, 65353, 65353, 65360, 65360, 65364, 65364, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73691, 73691, 73697, 73697, 73731, 73734, 73734, 73737, 73737, 73747, 73747, 73763, 73763, 73764, 73766, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73781, 73781, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73845, 73845, 73864, 73864, 73866, 73870, 73870, 73871, 74424, 74424, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74769, 74769, 74782, 74782, 77039, 77141, 77166, 77166, 77167, 77167, 77169, 77169, 77214, 77216, 77220, 77230, 77230, 77230, 77244, 77245, 77245, 77246, 77246, 77249, 77250, 77250, 77251, 77251, 77254, 77254, 77255, 77255, 77256, 77256, 77590, 77590, 77604, 77604, 77604, 77611, 77614, 77614, 77615, 77615, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77699, 77699, 77700, 77700, 77700, 77705, 77705, 77710, 77710, 77733, 77733, 77736, 77736, 77743, 77743, 78144, 80550, 80595, 80598, 80611, 80611, 80646, 80646, 80666, 80666, 80667, 80667, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80730, 80734, 80736, 80745, 80781, 80784, 80784, 80787, 80790, 80790, 80800, 80800, 80803, 80803, 80804, 80804, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81480, 81484, 81497, 81499, 81499, 81501, 81503, 81506, 81506, 81507, 81509, 81509, 81510, 81510, 81511, 81514, 81517, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81528, 81528, 81530, 81530, 81532, 81532, 81533, 81533, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81551, 81553, 81556, 81558, 81567, 81567, 81567, 81568, 81568, 81568, 81569, 81569, 81570, 81570, 81572, 81572, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81667, 81667, 82456, 82499, 82968, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83771, 83771, 83781, 83783, 83784, 83787, 83791, 83792, 83792, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83823, 83828, 83830, 83834, 83834, 83855, 83855, 83877, 83877, 83877, 83878, 83878, 83878, 83898, 83898, 83899, 83899, 83903, 83921, 83921, 84313, 84313, 84314, 84314, 84315, 84315, 84318, 84318, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84468, 84470, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84484, 84488, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84496, 84501, 84503, 84503, 84521, 84530, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84539, 84539, 84541, 84546, 84546, 84547, 84547, 84569, 84569, 84570, 84570, 84571, 84571, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84908, 84984, 84984, 84984, 84997, 85004, 85004, 85010, 85010, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85039, 85039, 85040, 85040, 85041, 85041, 85064, 85064, 85065, 85065, 85069, 85069, 85070, 85070, 85071, 85071, 85074, 85079, 85084, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85111, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85164, 85165, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85211, 85213, 85215, 85215, 85217, 85218, 85220, 85220, 85222, 85443, 85445, 85530, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85647, 85647, 85664, 85664, 85665, 85665, 85672, 85673, 85674, 85684, 85684, 85685, 85685, 85685, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85709, 85709, 85710, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85718, 85720, 85723, 85723, 85728, 85728, 85729, 85729, 85814, 86012, 86012, 86049, 86070, 86743, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87343, 87348, 87353, 87353, 87354, 87354, 87362, 87362, 87362, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87373, 87374, 87374, 87375, 87375, 87377, 87379, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87397, 87399, 87401, 87404, 87406, 87413, 87414, 87414, 87414, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87809, 87844, 87850, 87850, 87851, 87851, 87851, 87852, 87855, 87855, 87856, 87856, 87857, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87898, 87899, 87899, 87902, 87907, 87910, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87935, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 88180, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88204, 88206, 88208, 88208, 88208, 88211, 88212, 88213, 88216, 88219, 88228, 88228, 88229, 88229, 88232, 88232, 88235, 88235, 88238, 88238, 88238, 88283, 88283, 88864, 89011, 89580, 89660, 90102, 90103, 90104, 90364, 90369, 90397, 90397, 90400, 90402, 90405, 90410, 90411, 90412, 90413, 90414, 90414, 90417, 90418, 90418, 90421, 90421, 90424, 90424, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90438, 90682, 90682, 90683, 90683, 90684, 90684, 90688, 90694, 90704, 90717, 90740, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90758, 90761, 90764, 90815, 90822, 90829, 90836, 90843, 90850, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90962, 90965, 90966, 90972, 90977, 90982, 90987, 90997, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91008, 91009, 91010, 91011, 91012, 91013, 91016, 91016, 91018, 91018, 91019, 91019, 91021, 91021, 91028, 91320, 91321, 91394, 91424, 91429, 91434, 91439, 91444, 91449, 91476, 91540, 91587, 91587, 91587, 91588, 91588, 91588, 91590, 91590, 91590, 91609, 91611, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91643, 91644, 91646, 91647, 91649, 91653, 91654, 91657, 91666, 91675, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91718, 91718, 91719, 91754, 91840, 91896, 92091, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92330, 92370, 92381, 92698, 92703, 92725, 92729, 92776, 92827, 92828, 92922, 93055, 93241, 93276, 93286, 93348, 93532, 93607, 93729, 93791, 93794, 93811, 93899, 94324, 94396, 94397, 94398, 94427, 94427, 94427, 94429, 94429, 94429, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94447, 94451, 94458, 94462, 94498, 94498, 94502, 94502, 94506, 94506, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94566, 94569, 94575, 94579, 94583, 94587, 94591, 94599, 94599, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94709, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94749, 94751, 94751, 94849, 94851, 94860, 94862, 94862, 95054, 95057, 95063, 95134, 95136, 95136, 95138, 95138, 95194, 95194, 95199, 95204, 95248, 95250, 95252, 95255, 95274, 95279, 95284, 95301, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95337, 95338, 95339, 95340, 95343, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95506, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95579, 95580, 95581, 95582, 95583, 95584, 95587, 95591, 95606, 95626, 95628, 95633, 95637, 95641, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95800, 95805, 95821, 95899, 96112, 96113, 96126, 96167, 96193, 96195, 96198, 96231, 96388, 96404, 96495, 96496, 96497, 96498, 96740, 96823, 96833, 96837, 96853, 96862, 96868, 96894, 96898, 96945, 96970, 97020, 97021, 97022, 97035, 97162, 97212, 97213, 97215, 97216, 97272, 97276, 97333, 97335, 97341, 97378, 97387, 97394, 97647, 97651, 97719, 97721, 97721, 97725, 97840, 97843, 97844, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97949, 97954, 97982, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98070, 98073, 98076, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98090, 98094, 98098, 98103, 98129, 98130, 98131, 98157, 98159, 98189, 98429, 98432, 98491, 98493, 98493, 98502, 98511, 98511, 98516, 98516, 98521, 98528, 98534, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98621, 98719, 98736, 98863, 98866, 98881, 98892, 98900, 98923, 98944, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99010, 99015, 99016, 99021, 99024, 99037, 99052, 99061, 99064, 99072, 99077, 99179, 99215, 99216, 99217, 99240, 99261, 99268, 99270, 99323, 99334, 99364, 99385, 99387, 99391, 99436, 99444, 99473, 99498, 99500, 99542, 99552, 99555, 99560, 99562, 99592, 99594, 99597, 99649) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` desc LIMIT 15 | 15 | 15 | 9 | 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 (6777, 6777, 6778, 6778, 6779, 6779, 12380, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34886, 34961, 34963, 34968, 34969, 34969, 34970, 34970, 34971, 34971, 34974, 34983, 35017, 35161, 35292, 35292, 35294, 35301, 35301, 35303, 35310, 35310, 35312, 35343, 35343, 35403, 35403, 35448, 35450, 35676, 35692, 35726, 35726, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35788, 35788, 38504, 38504, 44664, 44664, 44678, 44678, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44781, 44781, 44785, 44786, 44787, 44788, 45501, 45516, 45516, 45518, 45518, 45539, 45539, 54083, 54083, 54085, 54085, 54086, 54086, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58154, 58155, 58155, 58156, 58156, 58215, 58222, 58231, 58231, 58344, 58345, 58345, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64430, 64547, 64547, 64618, 64618, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64647, 64660, 64670, 64670, 64671, 64671, 64672, 64672, 65199, 65209, 65209, 65212, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65271, 65271, 65272, 65272, 65273, 65273, 65276, 65276, 65277, 65277, 65278, 65280, 65280, 65282, 65282, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65337, 65338, 65338, 65340, 65340, 65353, 65353, 65360, 65360, 65364, 65364, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73691, 73691, 73697, 73697, 73731, 73734, 73734, 73737, 73737, 73747, 73747, 73763, 73763, 73764, 73766, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73781, 73781, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73845, 73845, 73864, 73864, 73866, 73870, 73870, 73871, 74424, 74424, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74769, 74769, 74782, 74782, 77039, 77141, 77166, 77166, 77167, 77167, 77169, 77169, 77214, 77216, 77220, 77230, 77230, 77230, 77244, 77245, 77245, 77246, 77246, 77249, 77250, 77250, 77251, 77251, 77254, 77254, 77255, 77255, 77256, 77256, 77590, 77590, 77604, 77604, 77604, 77611, 77614, 77614, 77615, 77615, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77699, 77699, 77700, 77700, 77700, 77705, 77705, 77710, 77710, 77733, 77733, 77736, 77736, 77743, 77743, 78144, 80550, 80595, 80598, 80611, 80611, 80646, 80646, 80666, 80666, 80667, 80667, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80730, 80734, 80736, 80745, 80781, 80784, 80784, 80787, 80790, 80790, 80800, 80800, 80803, 80803, 80804, 80804, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81480, 81484, 81497, 81499, 81499, 81501, 81503, 81506, 81506, 81507, 81509, 81509, 81510, 81510, 81511, 81514, 81517, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81528, 81528, 81530, 81530, 81532, 81532, 81533, 81533, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81551, 81553, 81556, 81558, 81567, 81567, 81567, 81568, 81568, 81568, 81569, 81569, 81570, 81570, 81572, 81572, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81667, 81667, 82456, 82499, 82968, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83771, 83771, 83781, 83783, 83784, 83787, 83791, 83792, 83792, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83823, 83828, 83830, 83834, 83834, 83855, 83855, 83877, 83877, 83877, 83878, 83878, 83878, 83898, 83898, 83899, 83899, 83903, 83921, 83921, 84313, 84313, 84314, 84314, 84315, 84315, 84318, 84318, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84468, 84470, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84484, 84488, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84496, 84501, 84503, 84503, 84521, 84530, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84539, 84539, 84541, 84546, 84546, 84547, 84547, 84569, 84569, 84570, 84570, 84571, 84571, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84908, 84984, 84984, 84984, 84997, 85004, 85004, 85010, 85010, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85039, 85039, 85040, 85040, 85041, 85041, 85064, 85064, 85065, 85065, 85069, 85069, 85070, 85070, 85071, 85071, 85074, 85079, 85084, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85111, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85164, 85165, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85211, 85213, 85215, 85215, 85217, 85218, 85220, 85220, 85222, 85443, 85445, 85530, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85647, 85647, 85664, 85664, 85665, 85665, 85672, 85673, 85674, 85684, 85684, 85685, 85685, 85685, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85709, 85709, 85710, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85718, 85720, 85723, 85723, 85728, 85728, 85729, 85729, 85814, 86012, 86012, 86049, 86070, 86743, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87343, 87348, 87353, 87353, 87354, 87354, 87362, 87362, 87362, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87373, 87374, 87374, 87375, 87375, 87377, 87379, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87397, 87399, 87401, 87404, 87406, 87413, 87414, 87414, 87414, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87809, 87844, 87850, 87850, 87851, 87851, 87851, 87852, 87855, 87855, 87856, 87856, 87857, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87898, 87899, 87899, 87902, 87907, 87910, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87935, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 88180, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88204, 88206, 88208, 88208, 88208, 88211, 88212, 88213, 88216, 88219, 88228, 88228, 88229, 88229, 88232, 88232, 88235, 88235, 88238, 88238, 88238, 88283, 88283, 88864, 89011, 89580, 89660, 90102, 90103, 90104, 90364, 90369, 90397, 90397, 90400, 90402, 90405, 90410, 90411, 90412, 90413, 90414, 90414, 90417, 90418, 90418, 90421, 90421, 90424, 90424, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90438, 90682, 90682, 90683, 90683, 90684, 90684, 90688, 90694, 90704, 90717, 90740, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90758, 90761, 90764, 90815, 90822, 90829, 90836, 90843, 90850, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90962, 90965, 90966, 90972, 90977, 90982, 90987, 90997, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91008, 91009, 91010, 91011, 91012, 91013, 91016, 91016, 91018, 91018, 91019, 91019, 91021, 91021, 91028, 91320, 91321, 91394, 91424, 91429, 91434, 91439, 91444, 91449, 91476, 91540, 91587, 91587, 91587, 91588, 91588, 91588, 91590, 91590, 91590, 91609, 91611, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91643, 91644, 91646, 91647, 91649, 91653, 91654, 91657, 91666, 91675, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91718, 91718, 91719, 91754, 91840, 91896, 92091, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92330, 92370, 92381, 92698, 92703, 92725, 92729, 92776, 92827, 92828, 92922, 93055, 93241, 93276, 93286, 93348, 93532, 93607, 93729, 93791, 93794, 93811, 93899, 94324, 94396, 94397, 94398, 94427, 94427, 94427, 94429, 94429, 94429, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94447, 94451, 94458, 94462, 94498, 94498, 94502, 94502, 94506, 94506, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94566, 94569, 94575, 94579, 94583, 94587, 94591, 94599, 94599, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94709, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94749, 94751, 94751, 94849, 94851, 94860, 94862, 94862, 95054, 95057, 95063, 95134, 95136, 95136, 95138, 95138, 95194, 95194, 95199, 95204, 95248, 95250, 95252, 95255, 95274, 95279, 95284, 95301, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95337, 95338, 95339, 95340, 95343, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95506, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95579, 95580, 95581, 95582, 95583, 95584, 95587, 95591, 95606, 95626, 95628, 95633, 95637, 95641, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95800, 95805, 95821, 95899, 96112, 96113, 96126, 96167, 96193, 96195, 96198, 96231, 96388, 96404, 96495, 96496, 96497, 96498, 96740, 96823, 96833, 96837, 96853, 96862, 96868, 96894, 96898, 96945, 96970, 97020, 97021, 97022, 97035, 97162, 97212, 97213, 97215, 97216, 97272, 97276, 97333, 97335, 97341, 97378, 97387, 97394, 97647, 97651, 97719, 97721, 97721, 97725, 97840, 97843, 97844, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97949, 97954, 97982, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98070, 98073, 98076, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98090, 98094, 98098, 98103, 98129, 98130, 98131, 98157, 98159, 98189, 98429, 98432, 98491, 98493, 98493, 98502, 98511, 98511, 98516, 98516, 98521, 98528, 98534, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98621, 98719, 98736, 98863, 98866, 98881, 98892, 98900, 98923, 98944, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99010, 99015, 99016, 99021, 99024, 99037, 99052, 99061, 99064, 99072, 99077, 99179, 99215, 99216, 99217, 99240, 99261, 99268, 99270, 99323, 99334, 99364, 99385, 99387, 99391, 99436, 99444, 99473, 99498, 99500, 99542, 99552, 99555, 99560, 99562, 99592, 99594, 99597, 99649) AND `item_rank` <> 3 | 1 | 1 | 5 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96837) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2558G3A'))))) OR (((`item_id2` = 96837) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2558G3A'))))) OR (((`item_id3` = 96837) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2558G3A')))))) 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` = 96837 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98968) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2545G2B'))))) OR (((`item_id2` = 98968) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2545G2B'))))) OR (((`item_id3` = 98968) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2545G2B')))))) 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` = 98968 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92827) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25160G6'))))) OR (((`item_id2` = 92827) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25160G6'))))) OR (((`item_id3` = 92827) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25160G6')))))) 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` = 92827 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92091) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25108G3'))))) OR (((`item_id2` = 92091) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25108G3'))))) OR (((`item_id3` = 92091) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25108G3')))))) 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` = 92091 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98892) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2569G5C'))))) OR (((`item_id2` = 98892) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2569G5C'))))) OR (((`item_id3` = 98892) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2569G5C')))))) 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` = 98892 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96112) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25149G5A'))))) OR (((`item_id2` = 96112) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25149G5A'))))) OR (((`item_id3` = 96112) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25149G5A')))))) 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` = 96112 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96113) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25149G5B'))))) OR (((`item_id2` = 96113) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25149G5B'))))) OR (((`item_id3` = 96113) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25149G5B')))))) 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` = 96113 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96945) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2574G2B'))))) OR (((`item_id2` = 96945) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2574G2B'))))) OR (((`item_id3` = 96945) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2574G2B')))))) 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` = 96945 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89011) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25140G3A'))))) OR (((`item_id2` = 89011) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25140G3A'))))) OR (((`item_id3` = 89011) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25140G3A')))))) 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` = 89011 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98944) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2558G2A'))))) OR (((`item_id2` = 98944) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2558G2A'))))) OR (((`item_id3` = 98944) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2558G2A')))))) 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` = 98944 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98900) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2572G8A'))))) OR (((`item_id2` = 98900) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2572G8A'))))) OR (((`item_id3` = 98900) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2572G8A')))))) 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` = 98900 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98973) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2551G1C'))))) OR (((`item_id2` = 98973) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2551G1C'))))) OR (((`item_id3` = 98973) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2551G1C')))))) 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` = 98973 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93286) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2559G2A'))))) OR (((`item_id2` = 93286) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2559G2A'))))) OR (((`item_id3` = 93286) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2559G2A')))))) 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` = 93286 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99215) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25177G4'))))) OR (((`item_id2` = 99215) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25177G4'))))) OR (((`item_id3` = 99215) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25177G4')))))) 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` = 99215 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99552) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2535G3A'))))) OR (((`item_id2` = 99552) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2535G3A'))))) OR (((`item_id3` = 99552) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2535G3A')))))) 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` = 99552 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 | |