Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%[洗剤ギフト]%') OR (`Item`.`item_name` Like '%[洗剤ギフト]%') OR (`Item`.`item_figure` Like '%[洗剤ギフト]%') OR (`Item`.`item_color` Like '%[洗剤ギフト]%') OR (`Item`.`item_materials` Like '%[洗剤ギフト]%') OR (`Item`.`item_note` Like '%[洗剤ギフト]%') OR (`Item`.`item_code` Like '%花王%') OR (`Item`.`item_name` Like '%花王%') OR (`Item`.`item_figure` Like '%花王%') OR (`Item`.`item_color` Like '%花王%') OR (`Item`.`item_materials` Like '%花王%') OR (`Item`.`item_note` Like '%花王%') OR (`Item`.`item_code` Like '%キュキュットセット%') OR (`Item`.`item_name` Like '%キュキュットセット%') OR (`Item`.`item_figure` Like '%キュキュットセット%') OR (`Item`.`item_color` Like '%キュキュットセット%') OR (`Item`.`item_materials` Like '%キュキュットセット%') OR (`Item`.`item_note` Like '%キュキュットセット%') OR (`Item`.`item_code` Like '%C%') OR (`Item`.`item_name` Like '%C%') OR (`Item`.`item_figure` Like '%C%') OR (`Item`.`item_color` Like '%C%') OR (`Item`.`item_materials` Like '%C%') OR (`Item`.`item_note` Like '%C%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1788 | 1788 | 514 | 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 (6030, 6030, 6031, 6031, 6163, 6164, 6775, 6776, 12381, 34885, 34886, 35134, 35135, 35157, 35161, 35162, 35163, 35164, 35260, 35651, 35652, 36334, 44707, 45144, 45144, 54080, 54087, 54089, 54090, 57641, 57641, 57650, 57650, 57651, 57651, 57652, 57652, 57706, 57707, 57746, 58369, 58370, 58371, 58372, 64442, 64445, 64445, 64448, 64449, 64450, 64465, 64542, 64549, 64604, 64605, 64606, 64681, 65033, 65033, 65329, 65331, 65331, 65337, 65338, 65338, 68101, 68102, 68103, 68277, 68302, 68303, 68304, 68305, 68334, 68334, 68335, 68335, 68336, 68336, 68337, 68337, 68348, 69379, 71525, 71526, 71886, 71888, 72915, 72923, 72924, 73031, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 73527, 73527, 73528, 73528, 73614, 73643, 73647, 73650, 73650, 73657, 73658, 73667, 73667, 74201, 74203, 74205, 74206, 74208, 74209, 74210, 74211, 74212, 74213, 74215, 74217, 74219, 74220, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74238, 74239, 74240, 74241, 74242, 74243, 74245, 74247, 74249, 74250, 74251, 74252, 74256, 74257, 74259, 74262, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74280, 74281, 74282, 74283, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 75300, 75433, 75746, 76107, 77041, 77074, 77077, 77096, 77217, 77218, 77219, 77220, 77225, 77225, 77584, 77590, 77590, 77604, 77604, 77604, 77616, 77616, 77617, 77617, 77697, 77698, 77755, 77755, 78017, 78018, 78019, 78142, 78159, 79061, 79460, 80097, 80205, 80206, 80540, 80540, 80598, 80607, 80611, 80611, 80612, 80613, 80704, 80704, 80734, 80735, 80736, 80737, 80742, 80743, 80744, 80745, 81552, 81553, 81554, 81555, 81556, 81558, 81730, 82455, 82494, 82495, 82496, 82497, 82498, 82499, 82517, 82911, 82963, 82968, 82969, 83120, 83263, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83780, 83781, 83782, 83783, 83787, 83788, 83789, 83921, 83921, 84064, 84119, 84128, 84149, 84173, 84177, 84317, 84318, 84318, 84319, 84421, 84421, 84468, 84469, 84470, 84471, 84482, 84482, 84483, 84483, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84930, 84999, 85000, 85001, 85010, 85010, 85011, 85011, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85267, 85268, 85269, 85270, 85404, 85412, 85437, 85441, 85445, 85464, 85531, 85713, 85713, 85714, 85714, 85717, 85718, 85794, 85794, 86010, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86057, 86085, 86096, 86316, 86332, 86339, 86357, 86421, 86743, 86744, 86745, 86746, 86752, 86835, 86969, 86970, 87013, 87246, 87246, 87252, 87263, 87278, 87284, 87284, 87287, 87287, 87291, 87291, 87295, 87295, 87301, 87301, 87302, 87302, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87374, 87374, 87375, 87375, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87407, 87408, 87448, 87634, 87664, 87665, 87809, 87823, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 88204, 88205, 88206, 88207, 88277, 88278, 88279, 88280, 88283, 88283, 88455, 88463, 88499, 88647, 88863, 88884, 88885, 88886, 88887, 88905, 89067, 89203, 89405, 89467, 89467, 89511, 89539, 89552, 89556, 89616, 89661, 89933, 89996, 90026, 90027, 90028, 90231, 90329, 90340, 90361, 90362, 90363, 90368, 90369, 90402, 90403, 90404, 90405, 90406, 90407, 90416, 90417, 90427, 90428, 90451, 90451, 90452, 90452, 90461, 90461, 90463, 90463, 90470, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 91011, 91012, 91013, 91070, 91070, 91117, 91320, 91321, 91322, 91322, 91323, 91325, 91327, 91327, 91337, 91375, 91481, 91483, 91487, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91516, 91528, 91540, 91541, 91570, 91570, 91585, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91665, 91674, 91675, 91748, 91759, 91783, 91785, 91786, 91791, 91806, 91835, 91841, 91847, 91872, 91875, 91885, 91891, 91925, 91933, 91935, 91943, 91968, 91969, 91977, 92089, 92092, 92095, 92108, 92111, 92113, 92114, 92182, 92192, 92193, 92194, 92195, 92196, 92199, 92200, 92204, 92208, 92279, 92282, 92306, 92308, 92309, 92318, 92372, 92391, 92396, 92397, 92445, 92448, 92451, 92497, 92515, 92517, 92518, 92519, 92520, 92583, 92625, 92626, 92627, 92659, 92678, 92695, 92699, 92702, 92731, 92747, 92749, 92771, 92827, 92842, 92851, 92852, 92853, 92854, 92855, 92856, 92857, 92858, 92859, 92862, 92880, 92884, 92885, 92890, 92891, 92904, 92905, 92906, 92907, 92933, 92934, 92943, 92988, 92991, 92995, 93016, 93051, 93052, 93058, 93113, 93119, 93123, 93124, 93125, 93129, 93130, 93136, 93161, 93162, 93186, 93193, 93210, 93211, 93213, 93215, 93216, 93259, 93272, 93273, 93274, 93275, 93276, 93288, 93322, 93346, 93347, 93348, 93359, 93444, 93492, 93512, 93532, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93594, 93600, 93606, 93608, 93631, 93659, 93679, 93692, 93704, 93707, 93710, 93712, 93713, 93714, 93715, 93728, 93768, 93769, 93770, 93771, 93772, 93789, 93790, 93791, 93792, 93793, 93794, 93824, 93899, 93935, 93966, 93968, 93976, 93976, 93982, 93984, 93990, 94033, 94036, 94037, 94253, 94253, 94254, 94254, 94255, 94256, 94257, 94257, 94258, 94258, 94282, 94283, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94366, 94370, 94371, 94427, 94427, 94427, 94428, 94428, 94428, 94555, 94556, 94557, 94558, 94560, 94561, 94595, 94595, 94596, 94596, 94600, 94600, 94601, 94601, 94602, 94602, 94613, 94614, 94615, 94616, 94659, 94660, 94661, 94662, 94663, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94749, 94750, 94751, 94751, 94752, 94752, 94754, 94755, 94756, 94757, 94758, 94759, 94772, 94775, 94812, 94826, 95085, 95086, 95090, 95098, 95120, 95121, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95361, 95362, 95363, 95364, 95364, 95365, 95365, 95369, 95369, 95372, 95390, 95411, 95412, 95413, 95414, 95415, 95416, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95620, 95621, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95745, 95772, 95775, 95775, 95779, 95779, 95793, 95794, 95799, 95805, 95822, 95847, 95851, 95855, 95858, 95865, 95868, 95875, 95876, 95878, 95880, 95884, 95885, 95886, 95887, 95888, 95891, 95896, 95898, 95899, 95900, 95901, 95902, 95903, 95920, 95925, 95926, 95931, 95934, 95939, 95945, 95948, 95951, 95959, 95966, 95969, 95972, 95977, 95981, 95986, 96000, 96001, 96014, 96016, 96029, 96049, 96059, 96070, 96074, 96136, 96141, 96145, 96150, 96162, 96165, 96168, 96169, 96170, 96172, 96178, 96179, 96180, 96184, 96186, 96187, 96188, 96189, 96196, 96199, 96203, 96210, 96212, 96213, 96215, 96216, 96222, 96225, 96226, 96227, 96231, 96293, 96294, 96299, 96300, 96303, 96305, 96306, 96316, 96320, 96335, 96345, 96361, 96362, 96376, 96386, 96387, 96388, 96389, 96390, 96401, 96402, 96403, 96404, 96412, 96421, 96426, 96445, 96450, 96454, 96462, 96467, 96470, 96477, 96487, 96493, 96497, 96529, 96540, 96552, 96577, 96627, 96631, 96641, 96647, 96649, 96657, 96660, 96664, 96667, 96694, 96719, 96731, 96743, 96744, 96746, 96747, 96779, 96781, 96782, 96783, 96784, 96795, 96799, 96800, 96802, 96804, 96806, 96807, 96813, 96821, 96829, 96835, 96839, 96840, 96841, 96843, 96851, 96852, 96853, 96854, 96855, 96858, 96862, 96872, 96876, 96879, 96881, 96882, 96883, 96888, 96895, 96899, 96917, 96930, 96931, 96935, 96938, 96941, 96943, 96947, 96948, 96949, 96950, 96951, 96955, 96956, 96957, 96959, 96960, 96965, 96978, 96979, 96980, 96981, 96999, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97047, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97101, 97159, 97180, 97188, 97220, 97221, 97222, 97223, 97224, 97225, 97243, 97244, 97245, 97246, 97247, 97248, 97264, 97271, 97274, 97277, 97287, 97317, 97320, 97336, 97342, 97359, 97360, 97360, 97366, 97366, 97367, 97367, 97370, 97370, 97378, 97379, 97383, 97383, 97392, 97617, 97618, 97618, 97619, 97619, 97620, 97621, 97622, 97679, 97680, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97790, 97794, 97794, 97805, 97808, 97816, 97818, 97839, 97840, 97841, 97842, 97957, 97958, 97959, 98050, 98050, 98050, 98051, 98051, 98051, 98118, 98118, 98124, 98124, 98125, 98125, 98149, 98149, 98163, 98168, 98186, 98186, 98214, 98214, 98214, 98221, 98221, 98222, 98222, 98412, 98415, 98426, 98431, 98437, 98437, 98440, 98440, 98440, 98443, 98443, 98490, 98491, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98627, 98630, 98644, 98647, 98648, 98649, 98652, 98653, 98654, 98655, 98656, 98657, 98661, 98675, 98681, 98682, 98683, 98684, 98687, 98688, 98689, 98695, 98700, 98705, 98706, 98708, 98718, 98719, 98721, 98722, 98723, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98736, 98737, 98738, 98739, 98749, 98751, 98757, 98758, 98759, 98760, 98762, 98767, 98768, 98769, 98770, 98771, 98773, 98775, 98779, 98785, 98796, 98797, 98800, 98805, 98806, 98829, 98830, 98849, 98850, 98851, 98852, 98853, 98854, 98855, 98856, 98857, 98858, 98859, 98860, 98861, 98862, 98863, 98867, 98868, 98869, 98870, 98876, 98877, 98878, 98879, 98882, 98883, 98884, 98887, 98888, 98889, 98890, 98891, 98892, 98893, 98894, 98895, 98896, 98897, 98899, 98900, 98901, 98902, 98903, 98904, 98913, 98915, 98916, 98925, 98927, 98930, 98931, 98932, 98934, 98935, 98936, 98939, 98940, 98949, 98950, 98951, 98959, 98966, 98971, 98972, 98973, 98976, 98981, 98984, 98988, 98994, 98997, 99001, 99004, 99009, 99012, 99017, 99020, 99023, 99026, 99029, 99032, 99033, 99034, 99035, 99036, 99037, 99043, 99048, 99049, 99050, 99051, 99052, 99055, 99061, 99064, 99065, 99066, 99067, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99079, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99109, 99110, 99111, 99114, 99115, 99116, 99117, 99120, 99121, 99122, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99150, 99177, 99191, 99195, 99197, 99198, 99199, 99200, 99201, 99202, 99221, 99222, 99223, 99227, 99228, 99229, 99235, 99243, 99245, 99249, 99250, 99251, 99283, 99284, 99287, 99288, 99289, 99290, 99291, 99292, 99307, 99314, 99316, 99321, 99322, 99323, 99324, 99325, 99327, 99328, 99329, 99332, 99342, 99344, 99345, 99346, 99361, 99368, 99370, 99374, 99378, 99390, 99397, 99401, 99405, 99409, 99419, 99424, 99431, 99437, 99444, 99446, 99447, 99449, 99452, 99461, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99482, 99486, 99493, 99494, 99495, 99500, 99501, 99504, 99514, 99515, 99516, 99519, 99524, 99532, 99536, 99539, 99542, 99545, 99564, 99570, 99573, 99580, 99581, 99582, 99586, 99594, 99597, 99608, 99624, 99625, 99626, 99627, 99628, 99629, 99630, 99637, 99638, 99641, 99644, 99655, 99665, 99676, 99682, 99685, 99690, 99728, 99739, 99754, 99761, 99764, 99769, 99771, 99772, 99773, 99774, 99778) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 13 | 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, 6163, 6164, 6775, 6776, 12381, 34885, 34886, 35134, 35135, 35157, 35161, 35162, 35163, 35164, 35260, 35651, 35652, 36334, 44707, 45144, 45144, 54080, 54087, 54089, 54090, 57641, 57641, 57650, 57650, 57651, 57651, 57652, 57652, 57706, 57707, 57746, 58369, 58370, 58371, 58372, 64442, 64445, 64445, 64448, 64449, 64450, 64465, 64542, 64549, 64604, 64605, 64606, 64681, 65033, 65033, 65329, 65331, 65331, 65337, 65338, 65338, 68101, 68102, 68103, 68277, 68302, 68303, 68304, 68305, 68334, 68334, 68335, 68335, 68336, 68336, 68337, 68337, 68348, 69379, 71525, 71526, 71886, 71888, 72915, 72923, 72924, 73031, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 73527, 73527, 73528, 73528, 73614, 73643, 73647, 73650, 73650, 73657, 73658, 73667, 73667, 74201, 74203, 74205, 74206, 74208, 74209, 74210, 74211, 74212, 74213, 74215, 74217, 74219, 74220, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74238, 74239, 74240, 74241, 74242, 74243, 74245, 74247, 74249, 74250, 74251, 74252, 74256, 74257, 74259, 74262, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74280, 74281, 74282, 74283, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 75300, 75433, 75746, 76107, 77041, 77074, 77077, 77096, 77217, 77218, 77219, 77220, 77225, 77225, 77584, 77590, 77590, 77604, 77604, 77604, 77616, 77616, 77617, 77617, 77697, 77698, 77755, 77755, 78017, 78018, 78019, 78142, 78159, 79061, 79460, 80097, 80205, 80206, 80540, 80540, 80598, 80607, 80611, 80611, 80612, 80613, 80704, 80704, 80734, 80735, 80736, 80737, 80742, 80743, 80744, 80745, 81552, 81553, 81554, 81555, 81556, 81558, 81730, 82455, 82494, 82495, 82496, 82497, 82498, 82499, 82517, 82911, 82963, 82968, 82969, 83120, 83263, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83780, 83781, 83782, 83783, 83787, 83788, 83789, 83921, 83921, 84064, 84119, 84128, 84149, 84173, 84177, 84317, 84318, 84318, 84319, 84421, 84421, 84468, 84469, 84470, 84471, 84482, 84482, 84483, 84483, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84930, 84999, 85000, 85001, 85010, 85010, 85011, 85011, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85267, 85268, 85269, 85270, 85404, 85412, 85437, 85441, 85445, 85464, 85531, 85713, 85713, 85714, 85714, 85717, 85718, 85794, 85794, 86010, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86057, 86085, 86096, 86316, 86332, 86339, 86357, 86421, 86743, 86744, 86745, 86746, 86752, 86835, 86969, 86970, 87013, 87246, 87246, 87252, 87263, 87278, 87284, 87284, 87287, 87287, 87291, 87291, 87295, 87295, 87301, 87301, 87302, 87302, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87374, 87374, 87375, 87375, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87407, 87408, 87448, 87634, 87664, 87665, 87809, 87823, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 88204, 88205, 88206, 88207, 88277, 88278, 88279, 88280, 88283, 88283, 88455, 88463, 88499, 88647, 88863, 88884, 88885, 88886, 88887, 88905, 89067, 89203, 89405, 89467, 89467, 89511, 89539, 89552, 89556, 89616, 89661, 89933, 89996, 90026, 90027, 90028, 90231, 90329, 90340, 90361, 90362, 90363, 90368, 90369, 90402, 90403, 90404, 90405, 90406, 90407, 90416, 90417, 90427, 90428, 90451, 90451, 90452, 90452, 90461, 90461, 90463, 90463, 90470, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 91011, 91012, 91013, 91070, 91070, 91117, 91320, 91321, 91322, 91322, 91323, 91325, 91327, 91327, 91337, 91375, 91481, 91483, 91487, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91516, 91528, 91540, 91541, 91570, 91570, 91585, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91665, 91674, 91675, 91748, 91759, 91783, 91785, 91786, 91791, 91806, 91835, 91841, 91847, 91872, 91875, 91885, 91891, 91925, 91933, 91935, 91943, 91968, 91969, 91977, 92089, 92092, 92095, 92108, 92111, 92113, 92114, 92182, 92192, 92193, 92194, 92195, 92196, 92199, 92200, 92204, 92208, 92279, 92282, 92306, 92308, 92309, 92318, 92372, 92391, 92396, 92397, 92445, 92448, 92451, 92497, 92515, 92517, 92518, 92519, 92520, 92583, 92625, 92626, 92627, 92659, 92678, 92695, 92699, 92702, 92731, 92747, 92749, 92771, 92827, 92842, 92851, 92852, 92853, 92854, 92855, 92856, 92857, 92858, 92859, 92862, 92880, 92884, 92885, 92890, 92891, 92904, 92905, 92906, 92907, 92933, 92934, 92943, 92988, 92991, 92995, 93016, 93051, 93052, 93058, 93113, 93119, 93123, 93124, 93125, 93129, 93130, 93136, 93161, 93162, 93186, 93193, 93210, 93211, 93213, 93215, 93216, 93259, 93272, 93273, 93274, 93275, 93276, 93288, 93322, 93346, 93347, 93348, 93359, 93444, 93492, 93512, 93532, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93594, 93600, 93606, 93608, 93631, 93659, 93679, 93692, 93704, 93707, 93710, 93712, 93713, 93714, 93715, 93728, 93768, 93769, 93770, 93771, 93772, 93789, 93790, 93791, 93792, 93793, 93794, 93824, 93899, 93935, 93966, 93968, 93976, 93976, 93982, 93984, 93990, 94033, 94036, 94037, 94253, 94253, 94254, 94254, 94255, 94256, 94257, 94257, 94258, 94258, 94282, 94283, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94366, 94370, 94371, 94427, 94427, 94427, 94428, 94428, 94428, 94555, 94556, 94557, 94558, 94560, 94561, 94595, 94595, 94596, 94596, 94600, 94600, 94601, 94601, 94602, 94602, 94613, 94614, 94615, 94616, 94659, 94660, 94661, 94662, 94663, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94743, 94749, 94750, 94751, 94751, 94752, 94752, 94754, 94755, 94756, 94757, 94758, 94759, 94772, 94775, 94812, 94826, 95085, 95086, 95090, 95098, 95120, 95121, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95361, 95362, 95363, 95364, 95364, 95365, 95365, 95369, 95369, 95372, 95390, 95411, 95412, 95413, 95414, 95415, 95416, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95620, 95621, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95745, 95772, 95775, 95775, 95779, 95779, 95793, 95794, 95799, 95805, 95822, 95847, 95851, 95855, 95858, 95865, 95868, 95875, 95876, 95878, 95880, 95884, 95885, 95886, 95887, 95888, 95891, 95896, 95898, 95899, 95900, 95901, 95902, 95903, 95920, 95925, 95926, 95931, 95934, 95939, 95945, 95948, 95951, 95959, 95966, 95969, 95972, 95977, 95981, 95986, 96000, 96001, 96014, 96016, 96029, 96049, 96059, 96070, 96074, 96136, 96141, 96145, 96150, 96162, 96165, 96168, 96169, 96170, 96172, 96178, 96179, 96180, 96184, 96186, 96187, 96188, 96189, 96196, 96199, 96203, 96210, 96212, 96213, 96215, 96216, 96222, 96225, 96226, 96227, 96231, 96293, 96294, 96299, 96300, 96303, 96305, 96306, 96316, 96320, 96335, 96345, 96361, 96362, 96376, 96386, 96387, 96388, 96389, 96390, 96401, 96402, 96403, 96404, 96412, 96421, 96426, 96445, 96450, 96454, 96462, 96467, 96470, 96477, 96487, 96493, 96497, 96529, 96540, 96552, 96577, 96627, 96631, 96641, 96647, 96649, 96657, 96660, 96664, 96667, 96694, 96719, 96731, 96743, 96744, 96746, 96747, 96779, 96781, 96782, 96783, 96784, 96795, 96799, 96800, 96802, 96804, 96806, 96807, 96813, 96821, 96829, 96835, 96839, 96840, 96841, 96843, 96851, 96852, 96853, 96854, 96855, 96858, 96862, 96872, 96876, 96879, 96881, 96882, 96883, 96888, 96895, 96899, 96917, 96930, 96931, 96935, 96938, 96941, 96943, 96947, 96948, 96949, 96950, 96951, 96955, 96956, 96957, 96959, 96960, 96965, 96978, 96979, 96980, 96981, 96999, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97047, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97101, 97159, 97180, 97188, 97220, 97221, 97222, 97223, 97224, 97225, 97243, 97244, 97245, 97246, 97247, 97248, 97264, 97271, 97274, 97277, 97287, 97317, 97320, 97336, 97342, 97359, 97360, 97360, 97366, 97366, 97367, 97367, 97370, 97370, 97378, 97379, 97383, 97383, 97392, 97617, 97618, 97618, 97619, 97619, 97620, 97621, 97622, 97679, 97680, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97790, 97794, 97794, 97805, 97808, 97816, 97818, 97839, 97840, 97841, 97842, 97957, 97958, 97959, 98050, 98050, 98050, 98051, 98051, 98051, 98118, 98118, 98124, 98124, 98125, 98125, 98149, 98149, 98163, 98168, 98186, 98186, 98214, 98214, 98214, 98221, 98221, 98222, 98222, 98412, 98415, 98426, 98431, 98437, 98437, 98440, 98440, 98440, 98443, 98443, 98490, 98491, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98627, 98630, 98644, 98647, 98648, 98649, 98652, 98653, 98654, 98655, 98656, 98657, 98661, 98675, 98681, 98682, 98683, 98684, 98687, 98688, 98689, 98695, 98700, 98705, 98706, 98708, 98718, 98719, 98721, 98722, 98723, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98736, 98737, 98738, 98739, 98749, 98751, 98757, 98758, 98759, 98760, 98762, 98767, 98768, 98769, 98770, 98771, 98773, 98775, 98779, 98785, 98796, 98797, 98800, 98805, 98806, 98829, 98830, 98849, 98850, 98851, 98852, 98853, 98854, 98855, 98856, 98857, 98858, 98859, 98860, 98861, 98862, 98863, 98867, 98868, 98869, 98870, 98876, 98877, 98878, 98879, 98882, 98883, 98884, 98887, 98888, 98889, 98890, 98891, 98892, 98893, 98894, 98895, 98896, 98897, 98899, 98900, 98901, 98902, 98903, 98904, 98913, 98915, 98916, 98925, 98927, 98930, 98931, 98932, 98934, 98935, 98936, 98939, 98940, 98949, 98950, 98951, 98959, 98966, 98971, 98972, 98973, 98976, 98981, 98984, 98988, 98994, 98997, 99001, 99004, 99009, 99012, 99017, 99020, 99023, 99026, 99029, 99032, 99033, 99034, 99035, 99036, 99037, 99043, 99048, 99049, 99050, 99051, 99052, 99055, 99061, 99064, 99065, 99066, 99067, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99079, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99109, 99110, 99111, 99114, 99115, 99116, 99117, 99120, 99121, 99122, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99150, 99177, 99191, 99195, 99197, 99198, 99199, 99200, 99201, 99202, 99221, 99222, 99223, 99227, 99228, 99229, 99235, 99243, 99245, 99249, 99250, 99251, 99283, 99284, 99287, 99288, 99289, 99290, 99291, 99292, 99307, 99314, 99316, 99321, 99322, 99323, 99324, 99325, 99327, 99328, 99329, 99332, 99342, 99344, 99345, 99346, 99361, 99368, 99370, 99374, 99378, 99390, 99397, 99401, 99405, 99409, 99419, 99424, 99431, 99437, 99444, 99446, 99447, 99449, 99452, 99461, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99482, 99486, 99493, 99494, 99495, 99500, 99501, 99504, 99514, 99515, 99516, 99519, 99524, 99532, 99536, 99539, 99542, 99545, 99564, 99570, 99573, 99580, 99581, 99582, 99586, 99594, 99597, 99608, 99624, 99625, 99626, 99627, 99628, 99629, 99630, 99637, 99638, 99641, 99644, 99655, 99665, 99676, 99682, 99685, 99690, 99728, 99739, 99754, 99761, 99764, 99769, 99771, 99772, 99773, 99774, 99778) AND `item_rank` <> 3 | 1 | 1 | 7 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 82495) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G3B'))))) OR (((`item_id2` = 82495) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G3B'))))) OR (((`item_id3` = 82495) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G3B')))))) 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` = 82495 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 2 | 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` = 95969) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25320G11C'))))) OR (((`item_id2` = 95969) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25320G11C'))))) OR (((`item_id3` = 95969) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25320G11C')))))) 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` = 95969 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25285G9A'))))) OR (((`item_id2` = 92517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25285G9A'))))) OR (((`item_id3` = 92517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25285G9A')))))) 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` = 92517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) 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` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6776) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041846'))))) OR (((`item_id2` = 6776) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041846'))))) OR (((`item_id3` = 6776) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041846')))))) 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` = 6776 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325070'))))) OR (((`item_id2` = 95362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325070'))))) OR (((`item_id3` = 95362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325070')))))) 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` = 95362 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 | 1 | |
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` = 92995) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2535G5'))))) OR (((`item_id2` = 92995) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2535G5'))))) OR (((`item_id3` = 92995) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2535G5')))))) 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` = 92995 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93213) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25304G10'))))) OR (((`item_id2` = 93213) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25304G10'))))) OR (((`item_id3` = 93213) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25304G10')))))) 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` = 93213 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 | 1 | |
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` = 74333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0733NB'))))) OR (((`item_id2` = 74333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0733NB'))))) OR (((`item_id3` = 74333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0733NB')))))) 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` = 74333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96150) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25153G9C'))))) OR (((`item_id2` = 96150) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25153G9C'))))) OR (((`item_id3` = 96150) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25153G9C')))))) 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` = 96150 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98529) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0146-001'))))) OR (((`item_id2` = 98529) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0146-001'))))) OR (((`item_id3` = 98529) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0146-001')))))) 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` = 98529 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 | |