Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%日本製%') OR (`Item`.`item_name` Like '%日本製%') OR (`Item`.`item_figure` Like '%日本製%') OR (`Item`.`item_color` Like '%日本製%') OR (`Item`.`item_materials` Like '%日本製%') OR (`Item`.`item_note` Like '%日本製%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1292 | 1292 | 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 (54069, 58324, 64448, 64449, 64450, 65720, 65721, 65722, 66672, 68101, 68102, 68103, 68215, 68215, 68275, 68276, 68277, 68278, 68301, 68301, 68302, 68303, 68304, 68305, 68314, 68314, 68334, 68334, 68335, 68335, 68336, 68336, 68337, 68337, 68340, 68340, 68346, 68347, 68348, 68349, 68732, 69327, 71282, 71886, 71888, 71928, 72204, 72448, 72448, 72479, 72480, 72799, 72827, 72832, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73029, 73030, 73031, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 74944, 75431, 75432, 75433, 75434, 75438, 76813, 76890, 76930, 76933, 76937, 76942, 76977, 76977, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77327, 77329, 77330, 77331, 77332, 78795, 78795, 78989, 79061, 79239, 79239, 80205, 80206, 80233, 80330, 80366, 81547, 81548, 81549, 81550, 81551, 81872, 81886, 81905, 82070, 82080, 82453, 82454, 82455, 82456, 82494, 82495, 82496, 82497, 82498, 82499, 82515, 82516, 82517, 83109, 83120, 83261, 83262, 83263, 83264, 83265, 83530, 83563, 83584, 83726, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 83978, 83979, 83980, 83981, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84097, 84100, 84106, 84148, 84257, 84262, 84263, 85236, 85414, 85776, 85777, 85809, 85811, 86010, 86012, 86012, 86013, 86013, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 87275, 87653, 87654, 87662, 87783, 87784, 87785, 87786, 88173, 88396, 88453, 88454, 88455, 88460, 88461, 88463, 88479, 88497, 88498, 88499, 88526, 88530, 88905, 88925, 89075, 89089, 89117, 89179, 89201, 89202, 89203, 89204, 89205, 89292, 89312, 89467, 89467, 89489, 89497, 89532, 89539, 89616, 89745, 89746, 89837, 89894, 89931, 89932, 89933, 89944, 89945, 90014, 90027, 90028, 90048, 90066, 90102, 90103, 90104, 90122, 90123, 90124, 90190, 90231, 90234, 90353, 90354, 90356, 90357, 91029, 91030, 91031, 91032, 91033, 91034, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91347, 91367, 91371, 91375, 91509, 91509, 91511, 91795, 91896, 91897, 91975, 91976, 91998, 91999, 92000, 92022, 92023, 92048, 92049, 92052, 92061, 92064, 92065, 92068, 92070, 92071, 92072, 92074, 92075, 92076, 92085, 92086, 92101, 92133, 92134, 92136, 92137, 92150, 92151, 92180, 92181, 92182, 92183, 92185, 92186, 92192, 92193, 92194, 92195, 92196, 92197, 92198, 92199, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92286, 92287, 92304, 92305, 92306, 92308, 92309, 92324, 92325, 92333, 92334, 92336, 92355, 92356, 92357, 92358, 92359, 92360, 92361, 92383, 92583, 92609, 92676, 92677, 92678, 92847, 92851, 92852, 92853, 92854, 92855, 92856, 92857, 92858, 92859, 92860, 92861, 92862, 92863, 92893, 92901, 92912, 92918, 92925, 92959, 92961, 93002, 93003, 93004, 93005, 93012, 93040, 93041, 93051, 93055, 93056, 93058, 93064, 93113, 93119, 93123, 93124, 93125, 93130, 93136, 93161, 93171, 93178, 93185, 93186, 93189, 93193, 93198, 93210, 93211, 93214, 93215, 93216, 93229, 93231, 93232, 93236, 93241, 93243, 93244, 93251, 93256, 93261, 93264, 93267, 93300, 93301, 93302, 93320, 93321, 93322, 93323, 93324, 93325, 93359, 93371, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93486, 93512, 93568, 93600, 93608, 93655, 93656, 93657, 93658, 93659, 93660, 93661, 93662, 93675, 93676, 93677, 93678, 93679, 93680, 93681, 93682, 93683, 93688, 93689, 93690, 93691, 93692, 93693, 93694, 93695, 93696, 93697, 93698, 93699, 93700, 93701, 93704, 93705, 93706, 93707, 93708, 93709, 93710, 93711, 93712, 93713, 93714, 93715, 93726, 93727, 93728, 93729, 93730, 93733, 93734, 93735, 93736, 93741, 93768, 93769, 93770, 93771, 93772, 93784, 93785, 93786, 93787, 93788, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93885, 93897, 93898, 93899, 93922, 93923, 94571, 94572, 94573, 94574, 94767, 95374, 95375, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95609, 95612, 95786, 95787, 95851, 95853, 95854, 95855, 95856, 95857, 95858, 95884, 95887, 95888, 95889, 95890, 95891, 95896, 95901, 95902, 95903, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95997, 96006, 96008, 96009, 96014, 96015, 96020, 96036, 96037, 96038, 96039, 96040, 96041, 96042, 96043, 96046, 96047, 96048, 96049, 96050, 96058, 96059, 96060, 96061, 96064, 96065, 96066, 96067, 96089, 96090, 96120, 96121, 96122, 96126, 96127, 96128, 96129, 96130, 96132, 96133, 96138, 96139, 96140, 96141, 96143, 96144, 96145, 96146, 96147, 96186, 96187, 96188, 96189, 96209, 96223, 96224, 96236, 96237, 96238, 96239, 96240, 96245, 96246, 96247, 96248, 96254, 96257, 96271, 96285, 96286, 96289, 96293, 96294, 96299, 96300, 96303, 96305, 96306, 96308, 96316, 96317, 96320, 96330, 96339, 96340, 96341, 96342, 96343, 96344, 96346, 96347, 96349, 96354, 96373, 96374, 96375, 96376, 96430, 96495, 96496, 96497, 96498, 96512, 96557, 96570, 96577, 96579, 96583, 96685, 96686, 96687, 96690, 96691, 96692, 96693, 96694, 96695, 96696, 96697, 96698, 96701, 96702, 96703, 96704, 96709, 96710, 96746, 96751, 96753, 96755, 96756, 96757, 96760, 96761, 96762, 96765, 96766, 96789, 96790, 96792, 96794, 96802, 96815, 96818, 96819, 96821, 96822, 96863, 96869, 96879, 96880, 96881, 96882, 96883, 96931, 96934, 96935, 96953, 96954, 96955, 96956, 96957, 96959, 96960, 96961, 96964, 96968, 96969, 96970, 96971, 96972, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97044, 97048, 97049, 97052, 97057, 97058, 97060, 97070, 97079, 97121, 97122, 97123, 97130, 97131, 97134, 97135, 97136, 97139, 97140, 97141, 97142, 97143, 97144, 97155, 97158, 97161, 97162, 97173, 97174, 97175, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97197, 97198, 97199, 97200, 97201, 97202, 97212, 97213, 97214, 97215, 97216, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97240, 97241, 97242, 97269, 97270, 97271, 97272, 97273, 97274, 97279, 97280, 97281, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97292, 97307, 97308, 97309, 97310, 97311, 97312, 97313, 97314, 97318, 97319, 97320, 97321, 97322, 97323, 97326, 97334, 97335, 97336, 97337, 97339, 97340, 97341, 97342, 97343, 97344, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97834, 97838, 98189, 98190, 98218, 98631, 98632, 98651, 98666, 98670, 98671, 98672, 98673, 98674, 98675, 98676, 98677, 98678, 98699, 98700, 98701, 98703, 98705, 98706, 98755, 98761, 98781, 98782, 98789, 98790, 98795, 98796, 98797, 98802, 98803, 98804, 98811, 98813, 98814, 98815, 98816, 98817, 98819, 98821, 98822, 98824, 98825, 98840, 98841, 98842, 98843, 98844, 98846, 98864, 98865, 98876, 98877, 98878, 98879, 98905, 98912, 98914, 98915, 98916, 98919, 98920, 98922, 98923, 98924, 98925, 98926, 98953, 98954, 98957, 98958, 98959, 98961, 98962, 98963, 99027, 99028, 99029, 99038, 99039, 99040, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99106, 99107, 99108, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99118, 99119, 99121, 99122, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99140, 99143, 99152, 99153, 99154, 99155, 99161, 99162, 99165, 99167, 99168, 99169, 99170, 99171, 99172, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99200, 99201, 99202, 99203, 99204, 99205, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99224, 99225, 99226, 99230, 99231, 99232, 99233, 99234, 99235, 99239, 99240, 99241, 99242, 99243, 99244, 99246, 99247, 99251, 99252, 99255, 99256, 99257, 99258, 99259, 99260, 99261, 99262, 99263, 99267, 99268, 99269, 99270, 99271, 99272, 99273, 99274, 99275, 99300, 99301, 99302, 99304, 99318, 99321, 99322, 99323, 99324, 99325, 99326, 99392, 99393, 99394, 99416, 99450, 99451, 99452, 99453, 99454, 99455, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99474, 99477, 99478, 99479, 99480, 99481, 99482, 99483, 99484, 99485, 99486, 99487, 99488, 99489, 99506, 99507, 99508, 99509, 99510, 99549, 99568, 99569, 99570, 99578, 99579, 99580, 99581, 99582, 99584, 99585, 99586, 99587, 99588, 99589, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99602, 99603, 99626, 99627, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99673, 99679, 99683, 99684, 99685, 99686, 99687, 99688, 99689, 99690, 99691, 99692, 99693, 99694, 99695, 99697, 99704, 99707, 99708, 99709, 99710, 99711, 99712, 99719, 99720, 99721, 99722, 99732, 99744, 99751, 99759, 99760, 99761, 99765, 99766, 99767, 99768, 99769, 99770, 99771, 99772, 99773, 99774, 99775, 99776, 99777, 99778, 99779, 99780, 99781) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 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 (54069, 58324, 64448, 64449, 64450, 65720, 65721, 65722, 66672, 68101, 68102, 68103, 68215, 68215, 68275, 68276, 68277, 68278, 68301, 68301, 68302, 68303, 68304, 68305, 68314, 68314, 68334, 68334, 68335, 68335, 68336, 68336, 68337, 68337, 68340, 68340, 68346, 68347, 68348, 68349, 68732, 69327, 71282, 71886, 71888, 71928, 72204, 72448, 72448, 72479, 72480, 72799, 72827, 72832, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73029, 73030, 73031, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 74944, 75431, 75432, 75433, 75434, 75438, 76813, 76890, 76930, 76933, 76937, 76942, 76977, 76977, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77327, 77329, 77330, 77331, 77332, 78795, 78795, 78989, 79061, 79239, 79239, 80205, 80206, 80233, 80330, 80366, 81547, 81548, 81549, 81550, 81551, 81872, 81886, 81905, 82070, 82080, 82453, 82454, 82455, 82456, 82494, 82495, 82496, 82497, 82498, 82499, 82515, 82516, 82517, 83109, 83120, 83261, 83262, 83263, 83264, 83265, 83530, 83563, 83584, 83726, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 83978, 83979, 83980, 83981, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84097, 84100, 84106, 84148, 84257, 84262, 84263, 85236, 85414, 85776, 85777, 85809, 85811, 86010, 86012, 86012, 86013, 86013, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 87275, 87653, 87654, 87662, 87783, 87784, 87785, 87786, 88173, 88396, 88453, 88454, 88455, 88460, 88461, 88463, 88479, 88497, 88498, 88499, 88526, 88530, 88905, 88925, 89075, 89089, 89117, 89179, 89201, 89202, 89203, 89204, 89205, 89292, 89312, 89467, 89467, 89489, 89497, 89532, 89539, 89616, 89745, 89746, 89837, 89894, 89931, 89932, 89933, 89944, 89945, 90014, 90027, 90028, 90048, 90066, 90102, 90103, 90104, 90122, 90123, 90124, 90190, 90231, 90234, 90353, 90354, 90356, 90357, 91029, 91030, 91031, 91032, 91033, 91034, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91347, 91367, 91371, 91375, 91509, 91509, 91511, 91795, 91896, 91897, 91975, 91976, 91998, 91999, 92000, 92022, 92023, 92048, 92049, 92052, 92061, 92064, 92065, 92068, 92070, 92071, 92072, 92074, 92075, 92076, 92085, 92086, 92101, 92133, 92134, 92136, 92137, 92150, 92151, 92180, 92181, 92182, 92183, 92185, 92186, 92192, 92193, 92194, 92195, 92196, 92197, 92198, 92199, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92286, 92287, 92304, 92305, 92306, 92308, 92309, 92324, 92325, 92333, 92334, 92336, 92355, 92356, 92357, 92358, 92359, 92360, 92361, 92383, 92583, 92609, 92676, 92677, 92678, 92847, 92851, 92852, 92853, 92854, 92855, 92856, 92857, 92858, 92859, 92860, 92861, 92862, 92863, 92893, 92901, 92912, 92918, 92925, 92959, 92961, 93002, 93003, 93004, 93005, 93012, 93040, 93041, 93051, 93055, 93056, 93058, 93064, 93113, 93119, 93123, 93124, 93125, 93130, 93136, 93161, 93171, 93178, 93185, 93186, 93189, 93193, 93198, 93210, 93211, 93214, 93215, 93216, 93229, 93231, 93232, 93236, 93241, 93243, 93244, 93251, 93256, 93261, 93264, 93267, 93300, 93301, 93302, 93320, 93321, 93322, 93323, 93324, 93325, 93359, 93371, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93486, 93512, 93568, 93600, 93608, 93655, 93656, 93657, 93658, 93659, 93660, 93661, 93662, 93675, 93676, 93677, 93678, 93679, 93680, 93681, 93682, 93683, 93688, 93689, 93690, 93691, 93692, 93693, 93694, 93695, 93696, 93697, 93698, 93699, 93700, 93701, 93704, 93705, 93706, 93707, 93708, 93709, 93710, 93711, 93712, 93713, 93714, 93715, 93726, 93727, 93728, 93729, 93730, 93733, 93734, 93735, 93736, 93741, 93768, 93769, 93770, 93771, 93772, 93784, 93785, 93786, 93787, 93788, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93885, 93897, 93898, 93899, 93922, 93923, 94571, 94572, 94573, 94574, 94767, 95374, 95375, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95609, 95612, 95786, 95787, 95851, 95853, 95854, 95855, 95856, 95857, 95858, 95884, 95887, 95888, 95889, 95890, 95891, 95896, 95901, 95902, 95903, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95997, 96006, 96008, 96009, 96014, 96015, 96020, 96036, 96037, 96038, 96039, 96040, 96041, 96042, 96043, 96046, 96047, 96048, 96049, 96050, 96058, 96059, 96060, 96061, 96064, 96065, 96066, 96067, 96089, 96090, 96120, 96121, 96122, 96126, 96127, 96128, 96129, 96130, 96132, 96133, 96138, 96139, 96140, 96141, 96143, 96144, 96145, 96146, 96147, 96186, 96187, 96188, 96189, 96209, 96223, 96224, 96236, 96237, 96238, 96239, 96240, 96245, 96246, 96247, 96248, 96254, 96257, 96271, 96285, 96286, 96289, 96293, 96294, 96299, 96300, 96303, 96305, 96306, 96308, 96316, 96317, 96320, 96330, 96339, 96340, 96341, 96342, 96343, 96344, 96346, 96347, 96349, 96354, 96373, 96374, 96375, 96376, 96430, 96495, 96496, 96497, 96498, 96512, 96557, 96570, 96577, 96579, 96583, 96685, 96686, 96687, 96690, 96691, 96692, 96693, 96694, 96695, 96696, 96697, 96698, 96701, 96702, 96703, 96704, 96709, 96710, 96746, 96751, 96753, 96755, 96756, 96757, 96760, 96761, 96762, 96765, 96766, 96789, 96790, 96792, 96794, 96802, 96815, 96818, 96819, 96821, 96822, 96863, 96869, 96879, 96880, 96881, 96882, 96883, 96931, 96934, 96935, 96953, 96954, 96955, 96956, 96957, 96959, 96960, 96961, 96964, 96968, 96969, 96970, 96971, 96972, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97044, 97048, 97049, 97052, 97057, 97058, 97060, 97070, 97079, 97121, 97122, 97123, 97130, 97131, 97134, 97135, 97136, 97139, 97140, 97141, 97142, 97143, 97144, 97155, 97158, 97161, 97162, 97173, 97174, 97175, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97197, 97198, 97199, 97200, 97201, 97202, 97212, 97213, 97214, 97215, 97216, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97240, 97241, 97242, 97269, 97270, 97271, 97272, 97273, 97274, 97279, 97280, 97281, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97292, 97307, 97308, 97309, 97310, 97311, 97312, 97313, 97314, 97318, 97319, 97320, 97321, 97322, 97323, 97326, 97334, 97335, 97336, 97337, 97339, 97340, 97341, 97342, 97343, 97344, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97834, 97838, 98189, 98190, 98218, 98631, 98632, 98651, 98666, 98670, 98671, 98672, 98673, 98674, 98675, 98676, 98677, 98678, 98699, 98700, 98701, 98703, 98705, 98706, 98755, 98761, 98781, 98782, 98789, 98790, 98795, 98796, 98797, 98802, 98803, 98804, 98811, 98813, 98814, 98815, 98816, 98817, 98819, 98821, 98822, 98824, 98825, 98840, 98841, 98842, 98843, 98844, 98846, 98864, 98865, 98876, 98877, 98878, 98879, 98905, 98912, 98914, 98915, 98916, 98919, 98920, 98922, 98923, 98924, 98925, 98926, 98953, 98954, 98957, 98958, 98959, 98961, 98962, 98963, 99027, 99028, 99029, 99038, 99039, 99040, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99106, 99107, 99108, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99118, 99119, 99121, 99122, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99140, 99143, 99152, 99153, 99154, 99155, 99161, 99162, 99165, 99167, 99168, 99169, 99170, 99171, 99172, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99200, 99201, 99202, 99203, 99204, 99205, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99224, 99225, 99226, 99230, 99231, 99232, 99233, 99234, 99235, 99239, 99240, 99241, 99242, 99243, 99244, 99246, 99247, 99251, 99252, 99255, 99256, 99257, 99258, 99259, 99260, 99261, 99262, 99263, 99267, 99268, 99269, 99270, 99271, 99272, 99273, 99274, 99275, 99300, 99301, 99302, 99304, 99318, 99321, 99322, 99323, 99324, 99325, 99326, 99392, 99393, 99394, 99416, 99450, 99451, 99452, 99453, 99454, 99455, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99474, 99477, 99478, 99479, 99480, 99481, 99482, 99483, 99484, 99485, 99486, 99487, 99488, 99489, 99506, 99507, 99508, 99509, 99510, 99549, 99568, 99569, 99570, 99578, 99579, 99580, 99581, 99582, 99584, 99585, 99586, 99587, 99588, 99589, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99602, 99603, 99626, 99627, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99673, 99679, 99683, 99684, 99685, 99686, 99687, 99688, 99689, 99690, 99691, 99692, 99693, 99694, 99695, 99697, 99704, 99707, 99708, 99709, 99710, 99711, 99712, 99719, 99720, 99721, 99722, 99732, 99744, 99751, 99759, 99760, 99761, 99765, 99766, 99767, 99768, 99769, 99770, 99771, 99772, 99773, 99774, 99775, 99776, 99777, 99778, 99779, 99780, 99781) AND `item_rank` <> 3 | 1 | 1 | 8 | 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 | 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 | 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` = 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` = 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 | 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` = 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` = 93189) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G10'))))) OR (((`item_id2` = 93189) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G10'))))) OR (((`item_id3` = 93189) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G10')))))) 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` = 93189 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95970) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25320G12A'))))) OR (((`item_id2` = 95970) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25320G12A'))))) OR (((`item_id3` = 95970) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25320G12A')))))) 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` = 95970 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96048) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25289G8'))))) OR (((`item_id2` = 96048) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25289G8'))))) OR (((`item_id3` = 96048) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25289G8')))))) 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` = 96048 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96015) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25331G8'))))) OR (((`item_id2` = 96015) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25331G8'))))) OR (((`item_id3` = 96015) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25331G8')))))) 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` = 96015 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92074) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25300G3'))))) OR (((`item_id2` = 92074) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25300G3'))))) OR (((`item_id3` = 92074) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25300G3')))))) 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` = 92074 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73062) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25288G7'))))) OR (((`item_id2` = 73062) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25288G7'))))) OR (((`item_id3` = 73062) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25288G7')))))) 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` = 73062 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92048) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25306G11A'))))) OR (((`item_id2` = 92048) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25306G11A'))))) OR (((`item_id3` = 92048) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25306G11A')))))) 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` = 92048 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92049) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25306G11B'))))) OR (((`item_id2` = 92049) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25306G11B'))))) OR (((`item_id3` = 92049) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25306G11B')))))) 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` = 92049 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 68103) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25303G7C'))))) OR (((`item_id2` = 68103) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25303G7C'))))) OR (((`item_id3` = 68103) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25303G7C')))))) 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` = 68103 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91795) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25331G12'))))) OR (((`item_id2` = 91795) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25331G12'))))) OR (((`item_id3` = 91795) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25331G12')))))) 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` = 91795 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25272G7'))))) OR (((`item_id2` = 83726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25272G7'))))) OR (((`item_id3` = 83726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25272G7')))))) 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` = 83726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95964) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25302G6A'))))) OR (((`item_id2` = 95964) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25302G6A'))))) OR (((`item_id3` = 95964) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25302G6A')))))) 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` = 95964 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 | |