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 '%ABS%') OR (`Item`.`item_name` Like '%ABS%') OR (`Item`.`item_figure` Like '%ABS%') OR (`Item`.`item_color` Like '%ABS%') OR (`Item`.`item_materials` Like '%ABS%') OR (`Item`.`item_note` Like '%ABS%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1338 | 1338 | 1 | |
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 (6030, 6030, 6031, 6031, 6173, 6272, 6272, 6273, 6273, 6274, 6274, 6777, 6777, 6778, 6778, 6779, 6779, 12999, 13000, 35016, 35017, 35673, 35674, 35675, 35676, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 36242, 36243, 36244, 36245, 36246, 36770, 45144, 45144, 48175, 48176, 57641, 57641, 57644, 57645, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 58128, 58129, 58130, 58131, 58178, 64430, 64438, 64439, 64440, 64441, 64441, 64443, 64443, 64444, 64451, 64452, 64453, 64549, 64550, 64561, 64561, 65209, 65209, 65212, 65213, 68275, 68276, 68277, 68278, 68510, 69379, 69846, 70489, 73450, 73466, 73527, 73527, 73528, 73528, 73657, 73658, 73667, 73667, 73678, 73678, 73678, 73781, 73781, 74424, 74424, 74427, 74428, 74432, 74445, 74445, 74753, 74753, 74753, 74754, 74754, 74754, 75298, 75299, 75300, 75677, 75678, 75746, 76107, 76118, 76778, 77219, 77220, 77270, 77271, 77584, 77601, 77610, 77611, 77616, 77616, 77617, 77617, 77634, 77635, 77636, 77637, 77755, 77755, 78017, 78018, 78019, 79415, 79423, 80035, 80330, 80538, 80538, 80539, 80540, 80540, 80646, 80646, 80706, 80706, 81109, 81109, 81109, 81245, 81552, 81553, 81554, 81555, 81556, 81558, 82338, 82873, 82877, 82911, 82963, 82968, 82969, 83422, 83422, 83530, 83532, 83752, 83780, 83781, 83782, 83783, 83784, 83785, 83800, 83801, 83802, 83804, 83804, 83805, 83806, 83812, 83813, 83877, 83877, 83877, 83878, 83878, 83878, 83938, 83938, 83942, 84130, 84144, 84151, 84152, 84343, 84343, 84344, 84344, 84345, 84345, 84468, 84469, 84470, 84471, 84595, 84595, 84595, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85342, 85437, 85445, 85508, 85530, 85531, 85532, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85715, 85715, 85716, 85716, 85719, 85720, 85721, 86017, 86023, 86049, 86085, 86096, 86097, 86285, 86421, 86833, 86834, 86835, 86836, 86969, 86970, 86987, 86988, 87115, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87383, 87383, 87384, 87384, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87411, 87415, 87450, 87809, 87821, 87844, 87845, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87935, 88191, 88204, 88205, 88206, 88207, 88265, 88277, 88283, 88283, 88617, 88617, 88617, 88701, 88701, 88905, 88925, 88972, 89033, 89034, 89171, 89171, 89179, 89188, 89552, 89569, 89578, 89745, 89746, 89766, 89766, 89980, 90021, 90364, 90365, 90366, 90367, 90368, 90369, 90414, 90414, 90415, 90415, 90416, 90417, 90456, 90456, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90764, 90765, 90766, 91001, 91001, 91002, 91007, 91008, 91011, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91117, 91118, 91320, 91321, 91400, 91401, 91477, 91478, 91479, 91487, 91500, 91501, 91502, 91503, 91504, 91508, 91516, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91664, 91665, 91674, 91675, 91718, 91718, 91719, 91720, 91739, 91739, 91750, 91752, 91752, 91753, 91754, 91759, 91783, 91785, 91786, 91790, 91791, 91845, 91846, 91847, 91883, 91884, 91885, 91886, 91892, 91896, 91897, 91903, 91914, 91926, 91929, 91933, 91935, 91938, 91945, 91947, 91948, 91949, 91950, 91957, 91968, 91969, 91977, 91978, 92089, 92091, 92093, 92094, 92108, 92110, 92111, 92113, 92114, 92180, 92181, 92182, 92183, 92197, 92198, 92199, 92282, 92304, 92305, 92306, 92308, 92309, 92325, 92330, 92331, 92517, 92518, 92519, 92520, 92522, 92536, 92625, 92626, 92627, 92630, 92631, 92636, 92659, 92747, 92749, 92757, 92760, 92769, 92771, 92772, 92775, 92776, 92777, 92778, 92779, 92780, 92803, 92826, 92827, 92828, 92901, 92904, 92905, 92922, 92923, 92943, 92988, 92989, 92991, 92994, 92995, 92998, 92999, 93023, 93029, 93035, 93045, 93046, 93064, 93274, 93275, 93276, 93280, 93284, 93319, 93346, 93347, 93348, 93359, 93492, 93506, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93584, 93591, 93594, 93604, 93605, 93606, 93607, 93933, 93936, 93936, 93937, 93952, 93982, 94277, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94352, 94365, 94365, 94366, 94370, 94371, 94373, 94427, 94427, 94427, 94428, 94428, 94428, 94429, 94429, 94429, 94430, 94430, 94430, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94613, 94614, 94615, 94616, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94760, 94772, 94818, 94828, 94828, 94830, 94830, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 94861, 94861, 94862, 94862, 95137, 95137, 95138, 95138, 95164, 95183, 95186, 95186, 95187, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95367, 95434, 95435, 95436, 95437, 95609, 95612, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95629, 95630, 95631, 95632, 95633, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95771, 95773, 95775, 95775, 95781, 95782, 95786, 95795, 95796, 95829, 95832, 95898, 95899, 95904, 95920, 95921, 95924, 95998, 95999, 96000, 96001, 96091, 96148, 96149, 96150, 96160, 96161, 96162, 96179, 96180, 96182, 96183, 96184, 96185, 96192, 96193, 96194, 96195, 96196, 96211, 96215, 96216, 96234, 96236, 96238, 96354, 96386, 96392, 96393, 96395, 96403, 96404, 96409, 96419, 96420, 96421, 96423, 96425, 96426, 96440, 96445, 96446, 96450, 96456, 96491, 96492, 96493, 96494, 96529, 96542, 96543, 96561, 96567, 96641, 96645, 96647, 96649, 96650, 96663, 96669, 96671, 96677, 96713, 96718, 96720, 96731, 96736, 96740, 96741, 96742, 96779, 96781, 96782, 96783, 96795, 96799, 96800, 96802, 96806, 96807, 96808, 96823, 96824, 96825, 96829, 96830, 96831, 96832, 96833, 96834, 96835, 96836, 96843, 96846, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96867, 96868, 96872, 96880, 96901, 96902, 96937, 96941, 96949, 96950, 96951, 96965, 97376, 97377, 97377, 97378, 97382, 97382, 97617, 97620, 97621, 97622, 97623, 97624, 97625, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97791, 97799, 97840, 97841, 97842, 98050, 98050, 98050, 98051, 98051, 98051, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 98117, 98117, 98118, 98118, 98124, 98124, 98125, 98125, 98135, 98148, 98148, 98149, 98149, 98151, 98153, 98186, 98186, 98414, 98418, 98418, 98420, 98421, 98430, 98437, 98437, 98439, 98440, 98440, 98440, 98441, 98444, 98452, 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, 98522, 98523, 98524, 98525, 98526, 98527, 98528, 98631, 98632, 98647, 98648, 98649, 98670, 98679, 98680, 98681, 98682, 98683, 98684, 98685, 98686, 98687, 98693, 98694, 98695, 98696, 98697, 98698, 98701, 98702, 98704, 98708, 98709, 98711, 98714, 98715, 98716, 98717, 98718, 98719, 98720, 98722, 98723, 98724, 98735, 98736, 98737, 98738, 98739, 98741, 98742, 98743, 98745, 98747, 98748, 98750, 98756, 98757, 98759, 98760, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98775, 98777, 98778, 98779, 98780, 98781, 98782, 98829, 98849, 98850, 98851, 98852, 98853, 98854, 98855, 98856, 98857, 98858, 98859, 98860, 98861, 98862, 98863, 98864, 98865, 98866, 98867, 98871, 98872, 98876, 98877, 98878, 98879, 98888, 98889, 98890, 98891, 98892, 98913, 98932, 98934, 98935, 98936, 98937, 98938, 98939, 98940, 98941, 98942, 98943, 98947, 98948, 98949, 98950, 98951, 98952, 98967, 98968, 98969, 98970, 98971, 98972, 98973, 98974, 98975, 98976, 98977, 98978, 99033, 99034, 99035, 99036, 99037, 99039, 99040, 99064, 99065, 99066, 99067, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99279, 99280, 99281, 99287, 99288, 99289, 99290, 99291, 99292, 99297, 99300, 99303, 99312, 99347, 99348, 99349, 99350, 99351, 99352, 99353, 99354, 99355, 99356, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99368, 99369, 99370, 99371, 99414, 99415, 99444, 99445, 99446, 99447, 99448, 99449, 99450, 99451, 99452, 99453, 99454, 99455, 99472, 99473, 99475, 99496, 99497, 99500, 99501, 99533, 99551, 99552, 99553, 99555, 99556, 99560, 99561, 99562, 99563, 99564, 99567, 99572, 99621) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15, 15 | 15 | 15 | 5 | 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 (6030, 6030, 6031, 6031, 6173, 6272, 6272, 6273, 6273, 6274, 6274, 6777, 6777, 6778, 6778, 6779, 6779, 12999, 13000, 35016, 35017, 35673, 35674, 35675, 35676, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 36242, 36243, 36244, 36245, 36246, 36770, 45144, 45144, 48175, 48176, 57641, 57641, 57644, 57645, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 58128, 58129, 58130, 58131, 58178, 64430, 64438, 64439, 64440, 64441, 64441, 64443, 64443, 64444, 64451, 64452, 64453, 64549, 64550, 64561, 64561, 65209, 65209, 65212, 65213, 68275, 68276, 68277, 68278, 68510, 69379, 69846, 70489, 73450, 73466, 73527, 73527, 73528, 73528, 73657, 73658, 73667, 73667, 73678, 73678, 73678, 73781, 73781, 74424, 74424, 74427, 74428, 74432, 74445, 74445, 74753, 74753, 74753, 74754, 74754, 74754, 75298, 75299, 75300, 75677, 75678, 75746, 76107, 76118, 76778, 77219, 77220, 77270, 77271, 77584, 77601, 77610, 77611, 77616, 77616, 77617, 77617, 77634, 77635, 77636, 77637, 77755, 77755, 78017, 78018, 78019, 79415, 79423, 80035, 80330, 80538, 80538, 80539, 80540, 80540, 80646, 80646, 80706, 80706, 81109, 81109, 81109, 81245, 81552, 81553, 81554, 81555, 81556, 81558, 82338, 82873, 82877, 82911, 82963, 82968, 82969, 83422, 83422, 83530, 83532, 83752, 83780, 83781, 83782, 83783, 83784, 83785, 83800, 83801, 83802, 83804, 83804, 83805, 83806, 83812, 83813, 83877, 83877, 83877, 83878, 83878, 83878, 83938, 83938, 83942, 84130, 84144, 84151, 84152, 84343, 84343, 84344, 84344, 84345, 84345, 84468, 84469, 84470, 84471, 84595, 84595, 84595, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85342, 85437, 85445, 85508, 85530, 85531, 85532, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85715, 85715, 85716, 85716, 85719, 85720, 85721, 86017, 86023, 86049, 86085, 86096, 86097, 86285, 86421, 86833, 86834, 86835, 86836, 86969, 86970, 86987, 86988, 87115, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87383, 87383, 87384, 87384, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87411, 87415, 87450, 87809, 87821, 87844, 87845, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87935, 88191, 88204, 88205, 88206, 88207, 88265, 88277, 88283, 88283, 88617, 88617, 88617, 88701, 88701, 88905, 88925, 88972, 89033, 89034, 89171, 89171, 89179, 89188, 89552, 89569, 89578, 89745, 89746, 89766, 89766, 89980, 90021, 90364, 90365, 90366, 90367, 90368, 90369, 90414, 90414, 90415, 90415, 90416, 90417, 90456, 90456, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90764, 90765, 90766, 91001, 91001, 91002, 91007, 91008, 91011, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91117, 91118, 91320, 91321, 91400, 91401, 91477, 91478, 91479, 91487, 91500, 91501, 91502, 91503, 91504, 91508, 91516, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91664, 91665, 91674, 91675, 91718, 91718, 91719, 91720, 91739, 91739, 91750, 91752, 91752, 91753, 91754, 91759, 91783, 91785, 91786, 91790, 91791, 91845, 91846, 91847, 91883, 91884, 91885, 91886, 91892, 91896, 91897, 91903, 91914, 91926, 91929, 91933, 91935, 91938, 91945, 91947, 91948, 91949, 91950, 91957, 91968, 91969, 91977, 91978, 92089, 92091, 92093, 92094, 92108, 92110, 92111, 92113, 92114, 92180, 92181, 92182, 92183, 92197, 92198, 92199, 92282, 92304, 92305, 92306, 92308, 92309, 92325, 92330, 92331, 92517, 92518, 92519, 92520, 92522, 92536, 92625, 92626, 92627, 92630, 92631, 92636, 92659, 92747, 92749, 92757, 92760, 92769, 92771, 92772, 92775, 92776, 92777, 92778, 92779, 92780, 92803, 92826, 92827, 92828, 92901, 92904, 92905, 92922, 92923, 92943, 92988, 92989, 92991, 92994, 92995, 92998, 92999, 93023, 93029, 93035, 93045, 93046, 93064, 93274, 93275, 93276, 93280, 93284, 93319, 93346, 93347, 93348, 93359, 93492, 93506, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93584, 93591, 93594, 93604, 93605, 93606, 93607, 93933, 93936, 93936, 93937, 93952, 93982, 94277, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94352, 94365, 94365, 94366, 94370, 94371, 94373, 94427, 94427, 94427, 94428, 94428, 94428, 94429, 94429, 94429, 94430, 94430, 94430, 94550, 94551, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94613, 94614, 94615, 94616, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94760, 94772, 94818, 94828, 94828, 94830, 94830, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 94861, 94861, 94862, 94862, 95137, 95137, 95138, 95138, 95164, 95183, 95186, 95186, 95187, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95367, 95434, 95435, 95436, 95437, 95609, 95612, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95629, 95630, 95631, 95632, 95633, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95771, 95773, 95775, 95775, 95781, 95782, 95786, 95795, 95796, 95829, 95832, 95898, 95899, 95904, 95920, 95921, 95924, 95998, 95999, 96000, 96001, 96091, 96148, 96149, 96150, 96160, 96161, 96162, 96179, 96180, 96182, 96183, 96184, 96185, 96192, 96193, 96194, 96195, 96196, 96211, 96215, 96216, 96234, 96236, 96238, 96354, 96386, 96392, 96393, 96395, 96403, 96404, 96409, 96419, 96420, 96421, 96423, 96425, 96426, 96440, 96445, 96446, 96450, 96456, 96491, 96492, 96493, 96494, 96529, 96542, 96543, 96561, 96567, 96641, 96645, 96647, 96649, 96650, 96663, 96669, 96671, 96677, 96713, 96718, 96720, 96731, 96736, 96740, 96741, 96742, 96779, 96781, 96782, 96783, 96795, 96799, 96800, 96802, 96806, 96807, 96808, 96823, 96824, 96825, 96829, 96830, 96831, 96832, 96833, 96834, 96835, 96836, 96843, 96846, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96867, 96868, 96872, 96880, 96901, 96902, 96937, 96941, 96949, 96950, 96951, 96965, 97376, 97377, 97377, 97378, 97382, 97382, 97617, 97620, 97621, 97622, 97623, 97624, 97625, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97791, 97799, 97840, 97841, 97842, 98050, 98050, 98050, 98051, 98051, 98051, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 98117, 98117, 98118, 98118, 98124, 98124, 98125, 98125, 98135, 98148, 98148, 98149, 98149, 98151, 98153, 98186, 98186, 98414, 98418, 98418, 98420, 98421, 98430, 98437, 98437, 98439, 98440, 98440, 98440, 98441, 98444, 98452, 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, 98522, 98523, 98524, 98525, 98526, 98527, 98528, 98631, 98632, 98647, 98648, 98649, 98670, 98679, 98680, 98681, 98682, 98683, 98684, 98685, 98686, 98687, 98693, 98694, 98695, 98696, 98697, 98698, 98701, 98702, 98704, 98708, 98709, 98711, 98714, 98715, 98716, 98717, 98718, 98719, 98720, 98722, 98723, 98724, 98735, 98736, 98737, 98738, 98739, 98741, 98742, 98743, 98745, 98747, 98748, 98750, 98756, 98757, 98759, 98760, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98775, 98777, 98778, 98779, 98780, 98781, 98782, 98829, 98849, 98850, 98851, 98852, 98853, 98854, 98855, 98856, 98857, 98858, 98859, 98860, 98861, 98862, 98863, 98864, 98865, 98866, 98867, 98871, 98872, 98876, 98877, 98878, 98879, 98888, 98889, 98890, 98891, 98892, 98913, 98932, 98934, 98935, 98936, 98937, 98938, 98939, 98940, 98941, 98942, 98943, 98947, 98948, 98949, 98950, 98951, 98952, 98967, 98968, 98969, 98970, 98971, 98972, 98973, 98974, 98975, 98976, 98977, 98978, 99033, 99034, 99035, 99036, 99037, 99039, 99040, 99064, 99065, 99066, 99067, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99279, 99280, 99281, 99287, 99288, 99289, 99290, 99291, 99292, 99297, 99300, 99303, 99312, 99347, 99348, 99349, 99350, 99351, 99352, 99353, 99354, 99355, 99356, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99368, 99369, 99370, 99371, 99414, 99415, 99444, 99445, 99446, 99447, 99448, 99449, 99450, 99451, 99452, 99453, 99454, 99455, 99472, 99473, 99475, 99496, 99497, 99500, 99501, 99533, 99551, 99552, 99553, 99555, 99556, 99560, 99561, 99562, 99563, 99564, 99567, 99572, 99621) AND `item_rank` <> 3 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1843-044'))))) OR (((`item_id2` = 94599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1843-044'))))) OR (((`item_id3` = 94599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1843-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` = 94599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97378) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2392250'))))) OR (((`item_id2` = 97378) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2392250'))))) OR (((`item_id3` = 97378) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2392250')))))) 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` = 97378 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95311) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0122-009'))))) OR (((`item_id2` = 95311) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0122-009'))))) OR (((`item_id3` = 95311) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0122-009')))))) 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` = 95311 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98504) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-011'))))) OR (((`item_id2` = 98504) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-011'))))) OR (((`item_id3` = 98504) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-011')))))) 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` = 98504 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98519) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0152-006'))))) OR (((`item_id2` = 98519) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0152-006'))))) OR (((`item_id3` = 98519) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0152-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` = 98519 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98503) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-008'))))) OR (((`item_id2` = 98503) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-008'))))) OR (((`item_id3` = 98503) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-008')))))) 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` = 98503 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98518) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0152-004'))))) OR (((`item_id2` = 98518) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0152-004'))))) OR (((`item_id3` = 98518) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0152-004')))))) 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` = 98518 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0152-002'))))) OR (((`item_id2` = 98517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0152-002'))))) OR (((`item_id3` = 98517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0152-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` = 98517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98501) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-038'))))) OR (((`item_id2` = 98501) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-038'))))) OR (((`item_id3` = 98501) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-038')))))) 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` = 98501 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-044'))))) OR (((`item_id2` = 98516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-044'))))) OR (((`item_id3` = 98516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98421) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36200'))))) OR (((`item_id2` = 98421) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36200'))))) OR (((`item_id3` = 98421) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36200')))))) 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` = 98421 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98452) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374881'))))) OR (((`item_id2` = 98452) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374881'))))) OR (((`item_id3` = 98452) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374881')))))) 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` = 98452 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98500) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-034'))))) OR (((`item_id2` = 98500) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-034'))))) OR (((`item_id3` = 98500) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-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` = 98500 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98515) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-009'))))) OR (((`item_id2` = 98515) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-009'))))) OR (((`item_id3` = 98515) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-009')))))) 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` = 98515 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98499) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-030'))))) OR (((`item_id2` = 98499) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-030'))))) OR (((`item_id3` = 98499) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-030')))))) 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` = 98499 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 | |