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 '%ポリエステル%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1825 | 1825 | 241 | 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 (6058, 6059, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 34874, 34875, 34907, 34908, 34909, 35018, 35026, 35026, 35027, 35027, 35059, 35059, 35105, 35178, 35179, 35180, 35188, 35189, 35190, 35243, 35244, 35245, 35252, 35254, 35255, 35562, 35564, 35568, 35569, 35572, 35574, 35574, 35578, 35578, 35579, 35579, 35596, 36242, 36243, 36244, 36245, 36246, 48175, 48176, 58128, 58129, 58130, 58131, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 58369, 58370, 58371, 58372, 64461, 64470, 64471, 64472, 64475, 64475, 64480, 64486, 64486, 64486, 64522, 64565, 64565, 64566, 64566, 64595, 64596, 64597, 64622, 64623, 64624, 64630, 64630, 64631, 64631, 64646, 64647, 64648, 64649, 64651, 64652, 64654, 64656, 64657, 64658, 64659, 64660, 64661, 64662, 64663, 64664, 64665, 64666, 64670, 64670, 64671, 64671, 64672, 64672, 65204, 65278, 65280, 65280, 65282, 65282, 68314, 68314, 69675, 71525, 71526, 71532, 71533, 73206, 73206, 73683, 73684, 73686, 73687, 73691, 73691, 73692, 73693, 73695, 73696, 73697, 73697, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73818, 73820, 73824, 73825, 73864, 73864, 73866, 73870, 73870, 73871, 76779, 77217, 77218, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77614, 77614, 77615, 77615, 77654, 77654, 77655, 77655, 77683, 77684, 77685, 77686, 77705, 77705, 77743, 77743, 80804, 80804, 80805, 81526, 81527, 81528, 81528, 81529, 81530, 81530, 81532, 81532, 81533, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81730, 82630, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83767, 83770, 83771, 83771, 83804, 83804, 83805, 83806, 83809, 83810, 83811, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83844, 83845, 83846, 83851, 83852, 83853, 83854, 83855, 83855, 83879, 83881, 83927, 84112, 84113, 84116, 84117, 84118, 84119, 84120, 84150, 84157, 84158, 84161, 84162, 84165, 84169, 84173, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84450, 84451, 84452, 84519, 84520, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84554, 84555, 84556, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84608, 84609, 84610, 84611, 84911, 84911, 84941, 84987, 84988, 84990, 84991, 84992, 84993, 84994, 84995, 84996, 84997, 85002, 85003, 85004, 85004, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270, 85389, 85399, 85404, 85412, 85444, 85505, 85520, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85728, 85728, 85729, 85729, 85763, 85768, 85794, 85794, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86070, 86072, 86074, 86075, 86078, 86332, 86339, 86436, 87014, 87246, 87246, 87263, 87311, 87311, 87312, 87312, 87313, 87313, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87407, 87408, 87410, 87448, 87722, 87722, 87723, 87723, 87724, 87725, 87726, 87727, 87728, 87729, 87730, 87731, 87740, 87741, 87742, 87743, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87748, 87749, 87750, 87751, 87752, 87753, 87754, 87755, 87756, 87757, 87796, 87813, 87822, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88157, 88158, 88159, 88198, 88199, 88200, 88201, 88202, 88203, 88268, 88594, 88595, 88847, 89295, 89316, 89552, 89556, 90325, 90329, 90340, 90397, 90397, 90411, 90412, 90413, 90427, 90428, 90449, 90451, 90451, 90452, 90452, 90461, 90461, 90462, 90463, 90463, 90689, 90689, 90690, 90690, 90705, 90706, 90707, 90708, 90747, 90748, 90749, 90764, 90765, 90766, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91027, 91028, 91033, 91034, 91057, 91061, 91070, 91070, 91115, 91133, 91134, 91136, 91137, 91332, 91387, 91399, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91481, 91483, 91490, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91512, 91517, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91643, 91644, 91647, 91660, 91661, 91662, 91663, 91665, 91666, 91667, 91668, 91669, 91670, 91671, 91672, 91673, 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, 91733, 91734, 91735, 91736, 91754, 91827, 91833, 91843, 91844, 91969, 92248, 92249, 92253, 92254, 92389, 92390, 92391, 92395, 92396, 92397, 92436, 92619, 92640, 92652, 92840, 92841, 92842, 92978, 93129, 93162, 93178, 93195, 93259, 93272, 93273, 93809, 93810, 93811, 93935, 93969, 93969, 93976, 93976, 93984, 93985, 93986, 93987, 93988, 93989, 93990, 94255, 94256, 94257, 94257, 94258, 94258, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94342, 94342, 94344, 94360, 94361, 94368, 94369, 94374, 94374, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94455, 94456, 94457, 94458, 94573, 94574, 94595, 94595, 94596, 94596, 94597, 94597, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94755, 94756, 94757, 94758, 94759, 94765, 94766, 94769, 94775, 94817, 94817, 94819, 94819, 94839, 94840, 94841, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 94863, 94864, 94865, 94866, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95070, 95070, 95071, 95071, 95072, 95072, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95090, 95098, 95148, 95149, 95150, 95159, 95161, 95161, 95162, 95162, 95165, 95166, 95167, 95168, 95169, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95180, 95185, 95188, 95189, 95189, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95347, 95348, 95349, 95350, 95352, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95361, 95371, 95374, 95375, 95376, 95377, 95389, 95390, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95433, 95433, 95524, 95525, 95526, 95527, 95528, 95529, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95598, 95599, 95600, 95601, 95615, 95618, 95619, 95620, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95763, 95764, 95765, 95768, 95774, 95774, 95776, 95778, 95778, 95779, 95779, 95787, 95788, 95791, 95792, 95793, 95811, 95830, 95863, 95864, 95865, 95866, 95867, 95868, 95869, 95892, 95925, 95926, 95939, 95940, 95941, 95944, 95945, 95975, 95976, 95977, 95978, 95979, 95980, 95981, 95982, 95983, 95984, 95985, 95986, 95987, 95988, 96065, 96066, 96067, 96301, 96310, 96379, 96381, 96410, 96411, 96412, 96413, 96417, 96418, 96430, 96432, 96470, 96475, 96476, 96477, 96478, 96504, 96531, 96532, 96533, 96534, 96538, 96539, 96540, 96542, 96543, 96589, 96590, 96593, 96596, 96597, 96609, 96640, 96647, 96660, 96661, 96666, 96667, 96668, 96684, 96689, 96767, 96809, 96810, 96812, 96814, 96817, 96818, 96819, 97053, 97275, 97276, 97277, 97294, 97295, 97296, 97297, 97359, 97360, 97360, 97365, 97369, 97376, 97379, 97382, 97382, 97612, 97613, 97614, 97625, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97682, 97683, 97684, 97685, 97688, 97689, 97690, 97691, 97692, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97719, 97784, 97785, 97786, 97787, 97788, 97794, 97794, 97795, 97797, 97799, 97800, 97801, 97802, 97803, 97804, 97808, 97809, 97810, 97813, 97816, 97817, 97843, 97844, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98128, 98136, 98137, 98138, 98139, 98140, 98141, 98142, 98143, 98144, 98145, 98145, 98146, 98146, 98147, 98147, 98156, 98157, 98166, 98167, 98168, 98174, 98174, 98175, 98175, 98176, 98219, 98220, 98419, 98433, 98433, 98435, 98442, 98442, 98443, 98443, 98444, 98453, 98455, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625, 98633, 98634, 98635, 98636, 98637, 98638, 98646, 98654, 98655, 98656, 98657, 98658, 98659, 98660, 98661, 98662, 98663, 98664, 98751, 98763, 98764, 98765, 98777, 98778, 98779, 98807, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98835, 98846, 98847, 98868, 98869, 98870, 98873, 98874, 98875, 98917, 98918, 98928, 98929, 98930, 98931, 98955, 98956, 98964, 98965, 98966, 98971, 98972, 98973, 99233, 99234, 99235, 99264, 99265, 99276, 99277, 99327, 99328, 99329, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99398, 99399, 99400, 99401, 99402, 99412, 99413, 99417, 99418, 99419, 99420, 99422, 99423, 99424, 99425, 99426, 99427, 99458, 99502, 99503, 99504, 99513, 99575, 99606, 99607, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99641, 99642, 99643, 99644, 99645, 99646, 99647, 99648, 99649, 99673, 99724, 99725, 99726, 99727, 99728, 99729, 99733, 99736, 99737, 99738, 99739, 99740, 99746, 99749) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 11 | 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 (6058, 6059, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 34874, 34875, 34907, 34908, 34909, 35018, 35026, 35026, 35027, 35027, 35059, 35059, 35105, 35178, 35179, 35180, 35188, 35189, 35190, 35243, 35244, 35245, 35252, 35254, 35255, 35562, 35564, 35568, 35569, 35572, 35574, 35574, 35578, 35578, 35579, 35579, 35596, 36242, 36243, 36244, 36245, 36246, 48175, 48176, 58128, 58129, 58130, 58131, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 58369, 58370, 58371, 58372, 64461, 64470, 64471, 64472, 64475, 64475, 64480, 64486, 64486, 64486, 64522, 64565, 64565, 64566, 64566, 64595, 64596, 64597, 64622, 64623, 64624, 64630, 64630, 64631, 64631, 64646, 64647, 64648, 64649, 64651, 64652, 64654, 64656, 64657, 64658, 64659, 64660, 64661, 64662, 64663, 64664, 64665, 64666, 64670, 64670, 64671, 64671, 64672, 64672, 65204, 65278, 65280, 65280, 65282, 65282, 68314, 68314, 69675, 71525, 71526, 71532, 71533, 73206, 73206, 73683, 73684, 73686, 73687, 73691, 73691, 73692, 73693, 73695, 73696, 73697, 73697, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73818, 73820, 73824, 73825, 73864, 73864, 73866, 73870, 73870, 73871, 76779, 77217, 77218, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77614, 77614, 77615, 77615, 77654, 77654, 77655, 77655, 77683, 77684, 77685, 77686, 77705, 77705, 77743, 77743, 80804, 80804, 80805, 81526, 81527, 81528, 81528, 81529, 81530, 81530, 81532, 81532, 81533, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81730, 82630, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83767, 83770, 83771, 83771, 83804, 83804, 83805, 83806, 83809, 83810, 83811, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83844, 83845, 83846, 83851, 83852, 83853, 83854, 83855, 83855, 83879, 83881, 83927, 84112, 84113, 84116, 84117, 84118, 84119, 84120, 84150, 84157, 84158, 84161, 84162, 84165, 84169, 84173, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84450, 84451, 84452, 84519, 84520, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84554, 84555, 84556, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84608, 84609, 84610, 84611, 84911, 84911, 84941, 84987, 84988, 84990, 84991, 84992, 84993, 84994, 84995, 84996, 84997, 85002, 85003, 85004, 85004, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270, 85389, 85399, 85404, 85412, 85444, 85505, 85520, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85728, 85728, 85729, 85729, 85763, 85768, 85794, 85794, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86070, 86072, 86074, 86075, 86078, 86332, 86339, 86436, 87014, 87246, 87246, 87263, 87311, 87311, 87312, 87312, 87313, 87313, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87407, 87408, 87410, 87448, 87722, 87722, 87723, 87723, 87724, 87725, 87726, 87727, 87728, 87729, 87730, 87731, 87740, 87741, 87742, 87743, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87748, 87749, 87750, 87751, 87752, 87753, 87754, 87755, 87756, 87757, 87796, 87813, 87822, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88157, 88158, 88159, 88198, 88199, 88200, 88201, 88202, 88203, 88268, 88594, 88595, 88847, 89295, 89316, 89552, 89556, 90325, 90329, 90340, 90397, 90397, 90411, 90412, 90413, 90427, 90428, 90449, 90451, 90451, 90452, 90452, 90461, 90461, 90462, 90463, 90463, 90689, 90689, 90690, 90690, 90705, 90706, 90707, 90708, 90747, 90748, 90749, 90764, 90765, 90766, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91027, 91028, 91033, 91034, 91057, 91061, 91070, 91070, 91115, 91133, 91134, 91136, 91137, 91332, 91387, 91399, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91481, 91483, 91490, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91512, 91517, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91643, 91644, 91647, 91660, 91661, 91662, 91663, 91665, 91666, 91667, 91668, 91669, 91670, 91671, 91672, 91673, 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, 91733, 91734, 91735, 91736, 91754, 91827, 91833, 91843, 91844, 91969, 92248, 92249, 92253, 92254, 92389, 92390, 92391, 92395, 92396, 92397, 92436, 92619, 92640, 92652, 92840, 92841, 92842, 92978, 93129, 93162, 93178, 93195, 93259, 93272, 93273, 93809, 93810, 93811, 93935, 93969, 93969, 93976, 93976, 93984, 93985, 93986, 93987, 93988, 93989, 93990, 94255, 94256, 94257, 94257, 94258, 94258, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94342, 94342, 94344, 94360, 94361, 94368, 94369, 94374, 94374, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94455, 94456, 94457, 94458, 94573, 94574, 94595, 94595, 94596, 94596, 94597, 94597, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94755, 94756, 94757, 94758, 94759, 94765, 94766, 94769, 94775, 94817, 94817, 94819, 94819, 94839, 94840, 94841, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 94863, 94864, 94865, 94866, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95070, 95070, 95071, 95071, 95072, 95072, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95090, 95098, 95148, 95149, 95150, 95159, 95161, 95161, 95162, 95162, 95165, 95166, 95167, 95168, 95169, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95180, 95185, 95188, 95189, 95189, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95347, 95348, 95349, 95350, 95352, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95361, 95371, 95374, 95375, 95376, 95377, 95389, 95390, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95433, 95433, 95524, 95525, 95526, 95527, 95528, 95529, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95598, 95599, 95600, 95601, 95615, 95618, 95619, 95620, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95763, 95764, 95765, 95768, 95774, 95774, 95776, 95778, 95778, 95779, 95779, 95787, 95788, 95791, 95792, 95793, 95811, 95830, 95863, 95864, 95865, 95866, 95867, 95868, 95869, 95892, 95925, 95926, 95939, 95940, 95941, 95944, 95945, 95975, 95976, 95977, 95978, 95979, 95980, 95981, 95982, 95983, 95984, 95985, 95986, 95987, 95988, 96065, 96066, 96067, 96301, 96310, 96379, 96381, 96410, 96411, 96412, 96413, 96417, 96418, 96430, 96432, 96470, 96475, 96476, 96477, 96478, 96504, 96531, 96532, 96533, 96534, 96538, 96539, 96540, 96542, 96543, 96589, 96590, 96593, 96596, 96597, 96609, 96640, 96647, 96660, 96661, 96666, 96667, 96668, 96684, 96689, 96767, 96809, 96810, 96812, 96814, 96817, 96818, 96819, 97053, 97275, 97276, 97277, 97294, 97295, 97296, 97297, 97359, 97360, 97360, 97365, 97369, 97376, 97379, 97382, 97382, 97612, 97613, 97614, 97625, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97682, 97683, 97684, 97685, 97688, 97689, 97690, 97691, 97692, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97719, 97784, 97785, 97786, 97787, 97788, 97794, 97794, 97795, 97797, 97799, 97800, 97801, 97802, 97803, 97804, 97808, 97809, 97810, 97813, 97816, 97817, 97843, 97844, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98128, 98136, 98137, 98138, 98139, 98140, 98141, 98142, 98143, 98144, 98145, 98145, 98146, 98146, 98147, 98147, 98156, 98157, 98166, 98167, 98168, 98174, 98174, 98175, 98175, 98176, 98219, 98220, 98419, 98433, 98433, 98435, 98442, 98442, 98443, 98443, 98444, 98453, 98455, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625, 98633, 98634, 98635, 98636, 98637, 98638, 98646, 98654, 98655, 98656, 98657, 98658, 98659, 98660, 98661, 98662, 98663, 98664, 98751, 98763, 98764, 98765, 98777, 98778, 98779, 98807, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98835, 98846, 98847, 98868, 98869, 98870, 98873, 98874, 98875, 98917, 98918, 98928, 98929, 98930, 98931, 98955, 98956, 98964, 98965, 98966, 98971, 98972, 98973, 99233, 99234, 99235, 99264, 99265, 99276, 99277, 99327, 99328, 99329, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99398, 99399, 99400, 99401, 99402, 99412, 99413, 99417, 99418, 99419, 99420, 99422, 99423, 99424, 99425, 99426, 99427, 99458, 99502, 99503, 99504, 99513, 99575, 99606, 99607, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99641, 99642, 99643, 99644, 99645, 99646, 99647, 99648, 99649, 99673, 99724, 99725, 99726, 99727, 99728, 99729, 99733, 99736, 99737, 99738, 99739, 99740, 99746, 99749) AND `item_rank` <> 3 | 1 | 1 | 10 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64657) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0728-006'))))) OR (((`item_id2` = 64657) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0728-006'))))) OR (((`item_id3` = 64657) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0728-006')))))) 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` = 64657 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95429) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1318-044'))))) OR (((`item_id2` = 95429) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1318-044'))))) OR (((`item_id3` = 95429) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1318-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` = 95429 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91680) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1233-028'))))) OR (((`item_id2` = 91680) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1233-028'))))) OR (((`item_id3` = 91680) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1233-028')))))) 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` = 91680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85147) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1063-006'))))) OR (((`item_id2` = 85147) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1063-006'))))) OR (((`item_id3` = 85147) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1063-006')))))) 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` = 85147 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 | 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` = 95774 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85156) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1061-006'))))) OR (((`item_id2` = 85156) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1061-006'))))) OR (((`item_id3` = 85156) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1061-006')))))) 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` = 85156 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97359) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325220'))))) OR (((`item_id2` = 97359) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325220'))))) OR (((`item_id3` = 97359) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325220')))))) 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` = 97359 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97360) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325230'))))) OR (((`item_id2` = 97360) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325230'))))) OR (((`item_id3` = 97360) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325230')))))) 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` = 97360 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-002'))))) OR (((`item_id2` = 77246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-002'))))) OR (((`item_id3` = 77246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-002')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 77246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83844) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0990-006'))))) OR (((`item_id2` = 83844) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0990-006'))))) OR (((`item_id3` = 83844) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0990-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 83844 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34874) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0342-006'))))) OR (((`item_id2` = 34874) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0342-006'))))) OR (((`item_id3` = 34874) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0342-006')))))) 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` = 34874 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64665) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0737-009'))))) OR (((`item_id2` = 64665) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0737-009'))))) OR (((`item_id3` = 64665) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0737-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` = 64665 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98564) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-044'))))) OR (((`item_id2` = 98564) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-044'))))) OR (((`item_id3` = 98564) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-044')))))) 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` = 98564 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-034'))))) OR (((`item_id2` = 98579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-034'))))) OR (((`item_id3` = 98579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-034')))))) 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` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-006')))))) 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` = 98609 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 | |