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 | 2058 | 2058 | 402 | 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 (6064, 6163, 6164, 6777, 6777, 34865, 34936, 34936, 35018, 35026, 35026, 35179, 35180, 35188, 35189, 35190, 35244, 35252, 35254, 35271, 35326, 35328, 35402, 35403, 35403, 35404, 35528, 35536, 35537, 35562, 35568, 35574, 35574, 35579, 35579, 35625, 35626, 35651, 35652, 35673, 35674, 35675, 35676, 35699, 35724, 35724, 35725, 35725, 35726, 35726, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 44694, 44761, 44761, 44762, 44762, 44763, 44764, 45516, 45516, 45539, 45539, 54080, 54082, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 57747, 57748, 57765, 64448, 64475, 64475, 64476, 64582, 64618, 64618, 64622, 64651, 64654, 64658, 64662, 64665, 64671, 64671, 64674, 65202, 65203, 65220, 65220, 65221, 65221, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65329, 65331, 65331, 65337, 65338, 65338, 65351, 65366, 65739, 65809, 68101, 68102, 68103, 68215, 68215, 68275, 68276, 68277, 68278, 68314, 68314, 68340, 68340, 68346, 68347, 68348, 68349, 68606, 68607, 70489, 71533, 72923, 72924, 73527, 73527, 73528, 73528, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73727, 73767, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73830, 73832, 73833, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 74779, 74780, 74782, 74782, 75298, 75299, 75300, 76977, 76977, 77145, 77149, 77166, 77166, 77167, 77167, 77186, 77213, 77214, 77219, 77220, 77270, 77271, 77329, 77584, 77655, 77655, 77658, 77658, 77660, 77660, 77733, 77733, 77736, 77736, 77755, 77755, 78017, 78018, 78019, 78144, 80097, 80607, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80678, 80679, 80680, 80681, 80692, 80692, 80717, 80717, 80719, 80734, 80735, 80736, 80737, 80748, 80752, 80768, 80770, 80779, 80781, 80782, 80784, 80784, 80800, 80800, 81146, 81216, 81216, 81244, 81244, 81245, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81496, 81497, 81498, 81499, 81499, 81500, 81506, 81506, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81595, 81596, 81597, 81611, 81615, 81615, 81636, 81731, 83754, 83754, 83756, 83756, 83758, 83758, 83758, 83787, 83788, 83789, 83790, 83791, 83804, 83804, 83805, 83806, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83832, 83833, 83834, 83834, 83835, 83836, 83841, 83842, 83843, 83845, 83851, 83864, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83900, 83902, 83921, 83921, 83927, 83975, 83976, 84087, 84087, 84130, 84177, 84178, 84179, 84218, 84220, 84262, 84263, 84286, 84453, 84454, 84455, 84456, 84457, 84458, 84459, 84468, 84469, 84470, 84471, 84478, 84479, 84482, 84482, 84483, 84483, 84488, 84489, 84490, 84491, 84517, 84518, 84519, 84520, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84554, 84555, 84556, 84557, 84558, 84559, 84560, 84569, 84569, 84570, 84570, 84571, 84571, 84593, 84593, 84594, 84594, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84612, 84613, 84616, 84618, 84620, 84622, 84930, 84941, 84999, 85000, 85001, 85051, 85052, 85053, 85063, 85065, 85065, 85068, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85113, 85115, 85117, 85119, 85149, 85149, 85155, 85158, 85161, 85163, 85164, 85168, 85169, 85170, 85170, 85202, 85210, 85216, 85217, 85236, 85333, 85356, 85387, 85389, 85412, 85442, 85443, 85520, 85536, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85702, 85702, 85703, 85703, 85763, 86010, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86070, 86074, 86075, 86078, 86097, 86833, 86834, 86835, 86836, 87246, 87246, 87263, 87315, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87371, 87372, 87373, 87378, 87379, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87400, 87401, 87402, 87410, 87450, 87748, 87749, 87750, 87751, 87783, 87784, 87785, 87786, 87796, 87844, 87845, 87850, 87850, 87864, 87864, 87865, 87865, 87886, 87886, 87886, 87888, 87888, 87888, 87891, 87909, 87910, 88141, 88191, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88278, 88279, 88280, 88460, 88461, 88463, 88497, 88498, 88499, 89171, 89171, 89552, 89980, 89996, 90014, 90021, 90026, 90319, 90364, 90365, 90366, 90367, 90376, 90377, 90408, 90409, 90410, 90427, 90428, 90429, 90429, 90430, 90430, 90457, 90685, 90686, 90687, 90688, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90758, 90759, 90760, 90761, 90762, 90763, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 91003, 91003, 91003, 91004, 91004, 91004, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91033, 91034, 91037, 91068, 91082, 91083, 91137, 91325, 91332, 91337, 91375, 91386, 91387, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91481, 91511, 91512, 91568, 91582, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91616, 91616, 91619, 91619, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91645, 91646, 91647, 91648, 91649, 91660, 91661, 91662, 91663, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91687, 91687, 91690, 91690, 91693, 91693, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91705, 91705, 91708, 91708, 91719, 91720, 91749, 91753, 91754, 91802, 91803, 91805, 91833, 91834, 91843, 91844, 91891, 91969, 92089, 92092, 92094, 92108, 92111, 92113, 92114, 92136, 92137, 92180, 92181, 92182, 92183, 92192, 92193, 92194, 92195, 92196, 92197, 92198, 92199, 92206, 92207, 92208, 92209, 92358, 92516, 92626, 92627, 92641, 92646, 92713, 92760, 92778, 92780, 92828, 92831, 92847, 92866, 92867, 92933, 92934, 92943, 93119, 93123, 93151, 93272, 93273, 93286, 93287, 93288, 93300, 93301, 93378, 93534, 93536, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93591, 93726, 93727, 93728, 93729, 93730, 93748, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93812, 93822, 93823, 93824, 93881, 93969, 93969, 93979, 93982, 93984, 93985, 93990, 94269, 94270, 94318, 94318, 94319, 94319, 94321, 94321, 94322, 94322, 94343, 94343, 94353, 94357, 94358, 94368, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94396, 94397, 94398, 94418, 94418, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94550, 94551, 94559, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94668, 94669, 94670, 94671, 94672, 94689, 94690, 94691, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94709, 94710, 94711, 94712, 94713, 94714, 94746, 94747, 94755, 94761, 94765, 94766, 94775, 94827, 94827, 94831, 94847, 94848, 94849, 95052, 95053, 95054, 95055, 95056, 95057, 95087, 95098, 95109, 95120, 95130, 95131, 95132, 95133, 95134, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95150, 95153, 95156, 95163, 95186, 95186, 95205, 95206, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95247, 95248, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95340, 95347, 95348, 95349, 95353, 95354, 95355, 95359, 95359, 95368, 95374, 95375, 95406, 95411, 95412, 95415, 95416, 95417, 95418, 95419, 95420, 95424, 95425, 95426, 95427, 95428, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95524, 95525, 95526, 95527, 95528, 95529, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95576, 95577, 95578, 95585, 95586, 95595, 95596, 95597, 95602, 95604, 95605, 95607, 95610, 95613, 95642, 95643, 95644, 95645, 95654, 95655, 95662, 95663, 95664, 95665, 95666, 95667, 95680, 95681, 95682, 95683, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95770, 95784, 95784, 95829, 95850, 95851, 95864, 95866, 95867, 95868, 95869, 95940, 95952, 95976, 95997, 96006, 96016, 96036, 96097, 96098, 96115, 96116, 96117, 96118, 96163, 96164, 96165, 96166, 96167, 96178, 96180, 96197, 96198, 96199, 96215, 96229, 96230, 96231, 96293, 96294, 96298, 96304, 96307, 96309, 96328, 96341, 96345, 96355, 96386, 96423, 96425, 96437, 96444, 96450, 96485, 96486, 96487, 96491, 96492, 96493, 96494, 96495, 96496, 96497, 96498, 96504, 96507, 96508, 96509, 96539, 96543, 96550, 96551, 96552, 96561, 96567, 96577, 96588, 96593, 96639, 96661, 96729, 96740, 96741, 96749, 96750, 96755, 96762, 96765, 96766, 96795, 96812, 96833, 96834, 96835, 96852, 96853, 96854, 96855, 96858, 96869, 96872, 96882, 96957, 96959, 97035, 97063, 97083, 97084, 97089, 97130, 97162, 97177, 97200, 97201, 97202, 97222, 97223, 97224, 97225, 97236, 97237, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97284, 97292, 97312, 97313, 97338, 97358, 97360, 97360, 97367, 97367, 97375, 97376, 97377, 97377, 97378, 97380, 97381, 97387, 97391, 97392, 97620, 97621, 97622, 97623, 97624, 97676, 97686, 97687, 97688, 97689, 97712, 97713, 97714, 97715, 97716, 97716, 97717, 97717, 97718, 97718, 97722, 97723, 97724, 97725, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97789, 97794, 97794, 97796, 97797, 97798, 97800, 97801, 97802, 97803, 97804, 97812, 97813, 97814, 97822, 97823, 97824, 97828, 97843, 97844, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97974, 97975, 97976, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98050, 98050, 98050, 98051, 98051, 98051, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98108, 98110, 98145, 98145, 98149, 98149, 98160, 98161, 98163, 98167, 98180, 98181, 98187, 98188, 98214, 98214, 98214, 98215, 98215, 98215, 98414, 98423, 98426, 98438, 98443, 98443, 98483, 98484, 98490, 98491, 98492, 98492, 98493, 98493, 98494, 98495, 98496, 98497, 98498, 98499, 98500, 98501, 98502, 98503, 98504, 98505, 98506, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98517, 98518, 98519, 98520, 98521, 98533, 98534, 98535, 98536, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98627, 98630, 98631, 98654, 98655, 98656, 98663, 98668, 98669, 98704, 98708, 98711, 98715, 98716, 98722, 98723, 98740, 98744, 98749, 98767, 98769, 98777, 98778, 98779, 98789, 98790, 98796, 98805, 98806, 98807, 98809, 98815, 98816, 98817, 98821, 98822, 98836, 98848, 98908, 98909, 98917, 98918, 98932, 98935, 98938, 98939, 98944, 98945, 98951, 99021, 99022, 99023, 99024, 99025, 99026, 99030, 99031, 99032, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99059, 99060, 99061, 99062, 99063, 99064, 99065, 99066, 99067, 99077, 99078, 99079, 99080, 99081, 99115, 99116, 99117, 99236, 99278, 99284, 99301, 99303, 99312, 99354, 99359, 99360, 99361, 99368, 99394, 99443, 99460, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99475, 99496, 99577, 99590, 99591, 99608, 99617, 99620, 99648, 99736, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99775, 99780, 99781) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` 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 (6064, 6163, 6164, 6777, 6777, 34865, 34936, 34936, 35018, 35026, 35026, 35179, 35180, 35188, 35189, 35190, 35244, 35252, 35254, 35271, 35326, 35328, 35402, 35403, 35403, 35404, 35528, 35536, 35537, 35562, 35568, 35574, 35574, 35579, 35579, 35625, 35626, 35651, 35652, 35673, 35674, 35675, 35676, 35699, 35724, 35724, 35725, 35725, 35726, 35726, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 44694, 44761, 44761, 44762, 44762, 44763, 44764, 45516, 45516, 45539, 45539, 54080, 54082, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 57747, 57748, 57765, 64448, 64475, 64475, 64476, 64582, 64618, 64618, 64622, 64651, 64654, 64658, 64662, 64665, 64671, 64671, 64674, 65202, 65203, 65220, 65220, 65221, 65221, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65329, 65331, 65331, 65337, 65338, 65338, 65351, 65366, 65739, 65809, 68101, 68102, 68103, 68215, 68215, 68275, 68276, 68277, 68278, 68314, 68314, 68340, 68340, 68346, 68347, 68348, 68349, 68606, 68607, 70489, 71533, 72923, 72924, 73527, 73527, 73528, 73528, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73727, 73767, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73830, 73832, 73833, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 74779, 74780, 74782, 74782, 75298, 75299, 75300, 76977, 76977, 77145, 77149, 77166, 77166, 77167, 77167, 77186, 77213, 77214, 77219, 77220, 77270, 77271, 77329, 77584, 77655, 77655, 77658, 77658, 77660, 77660, 77733, 77733, 77736, 77736, 77755, 77755, 78017, 78018, 78019, 78144, 80097, 80607, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80678, 80679, 80680, 80681, 80692, 80692, 80717, 80717, 80719, 80734, 80735, 80736, 80737, 80748, 80752, 80768, 80770, 80779, 80781, 80782, 80784, 80784, 80800, 80800, 81146, 81216, 81216, 81244, 81244, 81245, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81496, 81497, 81498, 81499, 81499, 81500, 81506, 81506, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81595, 81596, 81597, 81611, 81615, 81615, 81636, 81731, 83754, 83754, 83756, 83756, 83758, 83758, 83758, 83787, 83788, 83789, 83790, 83791, 83804, 83804, 83805, 83806, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83832, 83833, 83834, 83834, 83835, 83836, 83841, 83842, 83843, 83845, 83851, 83864, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83900, 83902, 83921, 83921, 83927, 83975, 83976, 84087, 84087, 84130, 84177, 84178, 84179, 84218, 84220, 84262, 84263, 84286, 84453, 84454, 84455, 84456, 84457, 84458, 84459, 84468, 84469, 84470, 84471, 84478, 84479, 84482, 84482, 84483, 84483, 84488, 84489, 84490, 84491, 84517, 84518, 84519, 84520, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84554, 84555, 84556, 84557, 84558, 84559, 84560, 84569, 84569, 84570, 84570, 84571, 84571, 84593, 84593, 84594, 84594, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84612, 84613, 84616, 84618, 84620, 84622, 84930, 84941, 84999, 85000, 85001, 85051, 85052, 85053, 85063, 85065, 85065, 85068, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85113, 85115, 85117, 85119, 85149, 85149, 85155, 85158, 85161, 85163, 85164, 85168, 85169, 85170, 85170, 85202, 85210, 85216, 85217, 85236, 85333, 85356, 85387, 85389, 85412, 85442, 85443, 85520, 85536, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85702, 85702, 85703, 85703, 85763, 86010, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86070, 86074, 86075, 86078, 86097, 86833, 86834, 86835, 86836, 87246, 87246, 87263, 87315, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87371, 87372, 87373, 87378, 87379, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87400, 87401, 87402, 87410, 87450, 87748, 87749, 87750, 87751, 87783, 87784, 87785, 87786, 87796, 87844, 87845, 87850, 87850, 87864, 87864, 87865, 87865, 87886, 87886, 87886, 87888, 87888, 87888, 87891, 87909, 87910, 88141, 88191, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88278, 88279, 88280, 88460, 88461, 88463, 88497, 88498, 88499, 89171, 89171, 89552, 89980, 89996, 90014, 90021, 90026, 90319, 90364, 90365, 90366, 90367, 90376, 90377, 90408, 90409, 90410, 90427, 90428, 90429, 90429, 90430, 90430, 90457, 90685, 90686, 90687, 90688, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90758, 90759, 90760, 90761, 90762, 90763, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 91003, 91003, 91003, 91004, 91004, 91004, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91033, 91034, 91037, 91068, 91082, 91083, 91137, 91325, 91332, 91337, 91375, 91386, 91387, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91481, 91511, 91512, 91568, 91582, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91616, 91616, 91619, 91619, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91645, 91646, 91647, 91648, 91649, 91660, 91661, 91662, 91663, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91687, 91687, 91690, 91690, 91693, 91693, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91705, 91705, 91708, 91708, 91719, 91720, 91749, 91753, 91754, 91802, 91803, 91805, 91833, 91834, 91843, 91844, 91891, 91969, 92089, 92092, 92094, 92108, 92111, 92113, 92114, 92136, 92137, 92180, 92181, 92182, 92183, 92192, 92193, 92194, 92195, 92196, 92197, 92198, 92199, 92206, 92207, 92208, 92209, 92358, 92516, 92626, 92627, 92641, 92646, 92713, 92760, 92778, 92780, 92828, 92831, 92847, 92866, 92867, 92933, 92934, 92943, 93119, 93123, 93151, 93272, 93273, 93286, 93287, 93288, 93300, 93301, 93378, 93534, 93536, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93591, 93726, 93727, 93728, 93729, 93730, 93748, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93812, 93822, 93823, 93824, 93881, 93969, 93969, 93979, 93982, 93984, 93985, 93990, 94269, 94270, 94318, 94318, 94319, 94319, 94321, 94321, 94322, 94322, 94343, 94343, 94353, 94357, 94358, 94368, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94396, 94397, 94398, 94418, 94418, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94550, 94551, 94559, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94668, 94669, 94670, 94671, 94672, 94689, 94690, 94691, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94709, 94710, 94711, 94712, 94713, 94714, 94746, 94747, 94755, 94761, 94765, 94766, 94775, 94827, 94827, 94831, 94847, 94848, 94849, 95052, 95053, 95054, 95055, 95056, 95057, 95087, 95098, 95109, 95120, 95130, 95131, 95132, 95133, 95134, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95150, 95153, 95156, 95163, 95186, 95186, 95205, 95206, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95247, 95248, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95340, 95347, 95348, 95349, 95353, 95354, 95355, 95359, 95359, 95368, 95374, 95375, 95406, 95411, 95412, 95415, 95416, 95417, 95418, 95419, 95420, 95424, 95425, 95426, 95427, 95428, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95524, 95525, 95526, 95527, 95528, 95529, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95576, 95577, 95578, 95585, 95586, 95595, 95596, 95597, 95602, 95604, 95605, 95607, 95610, 95613, 95642, 95643, 95644, 95645, 95654, 95655, 95662, 95663, 95664, 95665, 95666, 95667, 95680, 95681, 95682, 95683, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95770, 95784, 95784, 95829, 95850, 95851, 95864, 95866, 95867, 95868, 95869, 95940, 95952, 95976, 95997, 96006, 96016, 96036, 96097, 96098, 96115, 96116, 96117, 96118, 96163, 96164, 96165, 96166, 96167, 96178, 96180, 96197, 96198, 96199, 96215, 96229, 96230, 96231, 96293, 96294, 96298, 96304, 96307, 96309, 96328, 96341, 96345, 96355, 96386, 96423, 96425, 96437, 96444, 96450, 96485, 96486, 96487, 96491, 96492, 96493, 96494, 96495, 96496, 96497, 96498, 96504, 96507, 96508, 96509, 96539, 96543, 96550, 96551, 96552, 96561, 96567, 96577, 96588, 96593, 96639, 96661, 96729, 96740, 96741, 96749, 96750, 96755, 96762, 96765, 96766, 96795, 96812, 96833, 96834, 96835, 96852, 96853, 96854, 96855, 96858, 96869, 96872, 96882, 96957, 96959, 97035, 97063, 97083, 97084, 97089, 97130, 97162, 97177, 97200, 97201, 97202, 97222, 97223, 97224, 97225, 97236, 97237, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97284, 97292, 97312, 97313, 97338, 97358, 97360, 97360, 97367, 97367, 97375, 97376, 97377, 97377, 97378, 97380, 97381, 97387, 97391, 97392, 97620, 97621, 97622, 97623, 97624, 97676, 97686, 97687, 97688, 97689, 97712, 97713, 97714, 97715, 97716, 97716, 97717, 97717, 97718, 97718, 97722, 97723, 97724, 97725, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97789, 97794, 97794, 97796, 97797, 97798, 97800, 97801, 97802, 97803, 97804, 97812, 97813, 97814, 97822, 97823, 97824, 97828, 97843, 97844, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97974, 97975, 97976, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98050, 98050, 98050, 98051, 98051, 98051, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98108, 98110, 98145, 98145, 98149, 98149, 98160, 98161, 98163, 98167, 98180, 98181, 98187, 98188, 98214, 98214, 98214, 98215, 98215, 98215, 98414, 98423, 98426, 98438, 98443, 98443, 98483, 98484, 98490, 98491, 98492, 98492, 98493, 98493, 98494, 98495, 98496, 98497, 98498, 98499, 98500, 98501, 98502, 98503, 98504, 98505, 98506, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98517, 98518, 98519, 98520, 98521, 98533, 98534, 98535, 98536, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98627, 98630, 98631, 98654, 98655, 98656, 98663, 98668, 98669, 98704, 98708, 98711, 98715, 98716, 98722, 98723, 98740, 98744, 98749, 98767, 98769, 98777, 98778, 98779, 98789, 98790, 98796, 98805, 98806, 98807, 98809, 98815, 98816, 98817, 98821, 98822, 98836, 98848, 98908, 98909, 98917, 98918, 98932, 98935, 98938, 98939, 98944, 98945, 98951, 99021, 99022, 99023, 99024, 99025, 99026, 99030, 99031, 99032, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99059, 99060, 99061, 99062, 99063, 99064, 99065, 99066, 99067, 99077, 99078, 99079, 99080, 99081, 99115, 99116, 99117, 99236, 99278, 99284, 99301, 99303, 99312, 99354, 99359, 99360, 99361, 99368, 99394, 99443, 99460, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99475, 99496, 99577, 99590, 99591, 99608, 99617, 99620, 99648, 99736, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99775, 99780, 99781) AND `item_rank` <> 3 | 1 | 1 | 9 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54080) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0991-009'))))) OR (((`item_id2` = 54080) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0991-009'))))) OR (((`item_id3` = 54080) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0991-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` = 54080 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0890-043'))))) OR (((`item_id2` = 77736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0890-043'))))) OR (((`item_id3` = 77736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0890-043')))))) 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` = 77736 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` = 94652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1824-044'))))) OR (((`item_id2` = 94652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1824-044'))))) OR (((`item_id3` = 94652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1824-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` = 94652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96197) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25261G9A'))))) OR (((`item_id2` = 96197) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25261G9A'))))) OR (((`item_id3` = 96197) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25261G9A')))))) 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` = 96197 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-033445FC'))))) OR (((`item_id2` = 74432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-033445FC'))))) OR (((`item_id3` = 74432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-033445FC')))))) 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` = 74432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92209) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25323G3D'))))) OR (((`item_id2` = 92209) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25323G3D'))))) OR (((`item_id3` = 92209) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25323G3D')))))) 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` = 92209 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94358) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35383SV'))))) OR (((`item_id2` = 94358) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35383SV'))))) OR (((`item_id3` = 94358) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35383SV')))))) 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` = 94358 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84454) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1005-028'))))) OR (((`item_id2` = 84454) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1005-028'))))) OR (((`item_id3` = 84454) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1005-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` = 84454 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846261'))))) OR (((`item_id2` = 95607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846261'))))) OR (((`item_id3` = 95607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846261')))))) 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` = 95607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35699) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0453-008'))))) OR (((`item_id2` = 35699) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0453-008'))))) OR (((`item_id3` = 35699) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0453-008')))))) 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` = 35699 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` = 98502) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-044'))))) OR (((`item_id2` = 98502) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-044'))))) OR (((`item_id3` = 98502) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-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` = 98502 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-044'))))) OR (((`item_id2` = 95645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-044'))))) OR (((`item_id3` = 95645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-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` = 95645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25277G9D'))))) OR (((`item_id2` = 92516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25277G9D'))))) OR (((`item_id3` = 92516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25277G9D')))))) 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` = 92516 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 | |