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 '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_name` Like '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_figure` Like '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_color` Like '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_materials` Like '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_note` Like '%シリコンシェイカーボール+目盛り付フロストボトル360ml%') OR (`Item`.`item_code` Like '%セット%') OR (`Item`.`item_name` Like '%セット%') OR (`Item`.`item_figure` Like '%セット%') OR (`Item`.`item_color` Like '%セット%') OR (`Item`.`item_materials` Like '%セット%') OR (`Item`.`item_note` Like '%セット%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1298 | 1298 | 333 | maybe slow |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (6064, 6173, 6516, 6775, 6776, 6777, 6777, 35134, 35135, 35416, 35417, 35420, 35447, 35448, 35724, 35724, 35725, 35725, 35726, 35726, 54036, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 54087, 54089, 54090, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64441, 64441, 64442, 64444, 64446, 64446, 64447, 64447, 64480, 64522, 64523, 64529, 64564, 64582, 64618, 64618, 65033, 65033, 68314, 68314, 68340, 68340, 69327, 69379, 69456, 70203, 71886, 71888, 71928, 72448, 72448, 73051, 73051, 73187, 73187, 73613, 73614, 73650, 73650, 73651, 73651, 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, 74432, 74439, 74440, 74446, 74450, 74944, 75438, 76269, 76270, 76813, 76929, 77081, 77084, 77084, 77096, 77225, 77225, 77590, 77590, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78134, 79023, 79023, 79061, 80205, 80206, 80233, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81150, 81150, 81670, 81671, 81672, 81886, 83530, 83726, 83936, 83969, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84100, 84106, 84128, 84155, 84257, 84313, 84313, 84314, 84314, 84315, 84315, 84317, 84318, 84318, 84319, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84350, 84351, 84352, 84353, 84354, 84355, 84906, 85154, 85155, 85156, 85157, 85158, 85159, 85333, 85334, 85398, 85414, 85455, 85458, 85459, 85460, 85461, 85462, 85463, 85464, 85491, 85505, 85531, 85768, 85809, 85811, 86055, 86057, 86059, 86096, 86436, 86496, 86636, 86733, 87039, 87271, 87272, 87274, 87275, 87278, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87311, 87311, 87312, 87312, 87313, 87313, 87450, 87634, 87653, 87654, 87662, 87664, 87665, 87752, 87753, 87754, 87755, 87756, 87757, 87820, 87821, 87822, 87906, 87907, 87908, 87925, 88173, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88497, 88498, 88499, 88530, 88853, 88853, 89089, 89456, 89456, 89467, 89467, 89532, 89539, 89837, 90010, 90028, 90048, 90122, 90123, 90124, 90323, 90323, 90353, 90354, 90356, 90357, 90390, 90391, 90436, 90437, 90438, 90439, 90457, 90467, 90468, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90992, 90993, 90994, 90995, 91029, 91030, 91037, 91068, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91117, 91124, 91125, 91320, 91321, 91322, 91322, 91323, 91325, 91327, 91327, 91328, 91328, 91329, 91332, 91337, 91347, 91367, 91371, 91375, 91386, 91388, 91481, 91483, 91507, 91507, 91509, 91509, 91511, 91557, 91560, 91567, 91568, 91570, 91570, 91585, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91759, 91904, 91929, 91975, 91976, 91998, 91999, 92000, 92061, 92064, 92065, 92133, 92134, 92286, 92318, 92383, 92441, 92442, 92496, 92497, 92517, 92518, 92519, 92520, 92522, 92523, 92524, 92535, 92536, 92547, 92549, 92551, 92552, 92553, 92583, 92619, 92646, 92708, 92831, 92850, 92880, 92893, 92912, 92918, 92933, 92934, 93002, 93003, 93004, 93005, 93012, 93055, 93056, 93058, 93113, 93119, 93123, 93124, 93125, 93129, 93161, 93193, 93261, 93300, 93301, 93302, 93430, 93453, 93454, 93455, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93584, 93592, 93594, 93631, 93636, 93661, 93662, 93700, 93701, 93704, 93768, 93769, 93770, 93771, 93772, 93786, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93807, 93808, 93810, 93811, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93881, 93883, 93934, 93934, 93952, 93955, 93956, 93956, 93966, 93972, 93982, 93984, 93990, 94033, 94036, 94037, 94280, 94281, 94282, 94283, 94321, 94321, 94322, 94322, 94348, 94427, 94427, 94427, 94428, 94428, 94428, 94546, 94547, 94548, 94549, 94563, 94564, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94735, 94735, 94735, 94736, 94736, 94736, 94751, 94751, 94752, 94752, 94754, 94763, 94767, 94769, 94772, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 94812, 95084, 95087, 95088, 95088, 95089, 95095, 95095, 95099, 95100, 95109, 95111, 95113, 95114, 95120, 95121, 95155, 95158, 95159, 95161, 95161, 95162, 95162, 95182, 95185, 95237, 95239, 95240, 95243, 95246, 95361, 95366, 95372, 95376, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 95411, 95412, 95413, 95414, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95654, 95655, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95743, 95745, 95850, 95875, 95876, 95878, 95880, 95884, 95886, 95892, 95900, 95901, 95902, 95903, 95912, 95919, 95940, 95941, 95974, 96004, 96005, 96008, 96009, 96014, 96021, 96022, 96040, 96041, 96042, 96043, 96049, 96059, 96064, 96066, 96067, 96123, 96124, 96151, 96152, 96163, 96164, 96165, 96166, 96167, 96178, 96210, 96228, 96246, 96247, 96251, 96253, 96266, 96275, 96277, 96299, 96300, 96303, 96305, 96311, 96361, 96362, 96363, 96364, 96365, 96373, 96379, 96402, 96403, 96404, 96409, 96456, 96467, 96469, 96504, 96515, 96516, 96554, 96557, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96638, 96639, 96647, 96660, 96684, 96685, 96686, 96687, 96689, 96690, 96692, 96694, 96696, 96704, 96709, 96710, 96743, 96744, 96746, 96747, 96758, 96763, 96784, 96789, 96790, 96804, 96807, 96813, 96851, 96953, 96954, 96956, 96957, 96959, 96967, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97064, 97068, 97069, 97080, 97089, 97099, 97100, 97101, 97102, 97106, 97135, 97136, 97138, 97149, 97150, 97151, 97156, 97163, 97170, 97177, 97197, 97198, 97199, 97200, 97201, 97202, 97203, 97204, 97205, 97209, 97210, 97211, 97217, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97243, 97244, 97245, 97246, 97249, 97250, 97253, 97279, 97282, 97293, 97294, 97295, 97310, 97365, 97370, 97370, 97376, 97378, 97383, 97383, 97390, 97392, 97395, 97426, 97428, 97429, 97607, 97608, 97612, 97613, 97614, 97677, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97789, 97790, 97792, 97793, 97797, 97798, 97807, 97812, 97816, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97837, 97838, 97839, 97876, 97877, 97878, 97879, 97880, 97881, 98061, 98061, 98061, 98062, 98062, 98062, 98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98116, 98162, 98163, 98164, 98168, 98174, 98174, 98177, 98177, 98181, 98185, 98190, 98205, 98206, 98209, 98216, 98217, 98456, 98457, 98458, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98482, 98483, 98484, 98488, 98489, 98533, 98534, 98535, 98536, 98651, 98671, 98672, 98673, 98674, 98675, 98678, 98688, 98689, 98690, 98698, 98699, 98707, 98711, 98712, 98722, 98723, 98744, 98753, 98754, 98761, 98763, 98787, 98788, 98797, 98805, 98807, 98824, 98825, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98833, 98834, 98835, 98836, 98837, 98838, 98839, 98845, 98848, 98866, 98873, 98874, 98912, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99121, 99122, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99138, 99142, 99143, 99144, 99145, 99146, 99157, 99166, 99175, 99176, 99179, 99200, 99201, 99202, 99203, 99204, 99206, 99207, 99208, 99209, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99227, 99229, 99230, 99231, 99232, 99236, 99237, 99238, 99280, 99284, 99291, 99292, 99297, 99303, 99313, 99314, 99316, 99319, 99321, 99322, 99392, 99413, 99476, 99477, 99478, 99483, 99488, 99489, 99490, 99491, 99492, 99557, 99588, 99589, 99590, 99591, 99628, 99650, 99673, 99698, 99699, 99700, 99701, 99702, 99703, 99708, 99711, 99714, 99715, 99716, 99723, 99724) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 10 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (6064, 6173, 6516, 6775, 6776, 6777, 6777, 35134, 35135, 35416, 35417, 35420, 35447, 35448, 35724, 35724, 35725, 35725, 35726, 35726, 54036, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 54087, 54089, 54090, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64441, 64441, 64442, 64444, 64446, 64446, 64447, 64447, 64480, 64522, 64523, 64529, 64564, 64582, 64618, 64618, 65033, 65033, 68314, 68314, 68340, 68340, 69327, 69379, 69456, 70203, 71886, 71888, 71928, 72448, 72448, 73051, 73051, 73187, 73187, 73613, 73614, 73650, 73650, 73651, 73651, 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, 74432, 74439, 74440, 74446, 74450, 74944, 75438, 76269, 76270, 76813, 76929, 77081, 77084, 77084, 77096, 77225, 77225, 77590, 77590, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78134, 79023, 79023, 79061, 80205, 80206, 80233, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81150, 81150, 81670, 81671, 81672, 81886, 83530, 83726, 83936, 83969, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84100, 84106, 84128, 84155, 84257, 84313, 84313, 84314, 84314, 84315, 84315, 84317, 84318, 84318, 84319, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84350, 84351, 84352, 84353, 84354, 84355, 84906, 85154, 85155, 85156, 85157, 85158, 85159, 85333, 85334, 85398, 85414, 85455, 85458, 85459, 85460, 85461, 85462, 85463, 85464, 85491, 85505, 85531, 85768, 85809, 85811, 86055, 86057, 86059, 86096, 86436, 86496, 86636, 86733, 87039, 87271, 87272, 87274, 87275, 87278, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87311, 87311, 87312, 87312, 87313, 87313, 87450, 87634, 87653, 87654, 87662, 87664, 87665, 87752, 87753, 87754, 87755, 87756, 87757, 87820, 87821, 87822, 87906, 87907, 87908, 87925, 88173, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88497, 88498, 88499, 88530, 88853, 88853, 89089, 89456, 89456, 89467, 89467, 89532, 89539, 89837, 90010, 90028, 90048, 90122, 90123, 90124, 90323, 90323, 90353, 90354, 90356, 90357, 90390, 90391, 90436, 90437, 90438, 90439, 90457, 90467, 90468, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90992, 90993, 90994, 90995, 91029, 91030, 91037, 91068, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91117, 91124, 91125, 91320, 91321, 91322, 91322, 91323, 91325, 91327, 91327, 91328, 91328, 91329, 91332, 91337, 91347, 91367, 91371, 91375, 91386, 91388, 91481, 91483, 91507, 91507, 91509, 91509, 91511, 91557, 91560, 91567, 91568, 91570, 91570, 91585, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91759, 91904, 91929, 91975, 91976, 91998, 91999, 92000, 92061, 92064, 92065, 92133, 92134, 92286, 92318, 92383, 92441, 92442, 92496, 92497, 92517, 92518, 92519, 92520, 92522, 92523, 92524, 92535, 92536, 92547, 92549, 92551, 92552, 92553, 92583, 92619, 92646, 92708, 92831, 92850, 92880, 92893, 92912, 92918, 92933, 92934, 93002, 93003, 93004, 93005, 93012, 93055, 93056, 93058, 93113, 93119, 93123, 93124, 93125, 93129, 93161, 93193, 93261, 93300, 93301, 93302, 93430, 93453, 93454, 93455, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93584, 93592, 93594, 93631, 93636, 93661, 93662, 93700, 93701, 93704, 93768, 93769, 93770, 93771, 93772, 93786, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93807, 93808, 93810, 93811, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93881, 93883, 93934, 93934, 93952, 93955, 93956, 93956, 93966, 93972, 93982, 93984, 93990, 94033, 94036, 94037, 94280, 94281, 94282, 94283, 94321, 94321, 94322, 94322, 94348, 94427, 94427, 94427, 94428, 94428, 94428, 94546, 94547, 94548, 94549, 94563, 94564, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94735, 94735, 94735, 94736, 94736, 94736, 94751, 94751, 94752, 94752, 94754, 94763, 94767, 94769, 94772, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 94812, 95084, 95087, 95088, 95088, 95089, 95095, 95095, 95099, 95100, 95109, 95111, 95113, 95114, 95120, 95121, 95155, 95158, 95159, 95161, 95161, 95162, 95162, 95182, 95185, 95237, 95239, 95240, 95243, 95246, 95361, 95366, 95372, 95376, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 95411, 95412, 95413, 95414, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95654, 95655, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95743, 95745, 95850, 95875, 95876, 95878, 95880, 95884, 95886, 95892, 95900, 95901, 95902, 95903, 95912, 95919, 95940, 95941, 95974, 96004, 96005, 96008, 96009, 96014, 96021, 96022, 96040, 96041, 96042, 96043, 96049, 96059, 96064, 96066, 96067, 96123, 96124, 96151, 96152, 96163, 96164, 96165, 96166, 96167, 96178, 96210, 96228, 96246, 96247, 96251, 96253, 96266, 96275, 96277, 96299, 96300, 96303, 96305, 96311, 96361, 96362, 96363, 96364, 96365, 96373, 96379, 96402, 96403, 96404, 96409, 96456, 96467, 96469, 96504, 96515, 96516, 96554, 96557, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96638, 96639, 96647, 96660, 96684, 96685, 96686, 96687, 96689, 96690, 96692, 96694, 96696, 96704, 96709, 96710, 96743, 96744, 96746, 96747, 96758, 96763, 96784, 96789, 96790, 96804, 96807, 96813, 96851, 96953, 96954, 96956, 96957, 96959, 96967, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97064, 97068, 97069, 97080, 97089, 97099, 97100, 97101, 97102, 97106, 97135, 97136, 97138, 97149, 97150, 97151, 97156, 97163, 97170, 97177, 97197, 97198, 97199, 97200, 97201, 97202, 97203, 97204, 97205, 97209, 97210, 97211, 97217, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97243, 97244, 97245, 97246, 97249, 97250, 97253, 97279, 97282, 97293, 97294, 97295, 97310, 97365, 97370, 97370, 97376, 97378, 97383, 97383, 97390, 97392, 97395, 97426, 97428, 97429, 97607, 97608, 97612, 97613, 97614, 97677, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97789, 97790, 97792, 97793, 97797, 97798, 97807, 97812, 97816, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97837, 97838, 97839, 97876, 97877, 97878, 97879, 97880, 97881, 98061, 98061, 98061, 98062, 98062, 98062, 98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98116, 98162, 98163, 98164, 98168, 98174, 98174, 98177, 98177, 98181, 98185, 98190, 98205, 98206, 98209, 98216, 98217, 98456, 98457, 98458, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98482, 98483, 98484, 98488, 98489, 98533, 98534, 98535, 98536, 98651, 98671, 98672, 98673, 98674, 98675, 98678, 98688, 98689, 98690, 98698, 98699, 98707, 98711, 98712, 98722, 98723, 98744, 98753, 98754, 98761, 98763, 98787, 98788, 98797, 98805, 98807, 98824, 98825, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98833, 98834, 98835, 98836, 98837, 98838, 98839, 98845, 98848, 98866, 98873, 98874, 98912, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99121, 99122, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99138, 99142, 99143, 99144, 99145, 99146, 99157, 99166, 99175, 99176, 99179, 99200, 99201, 99202, 99203, 99204, 99206, 99207, 99208, 99209, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99227, 99229, 99230, 99231, 99232, 99236, 99237, 99238, 99280, 99284, 99291, 99292, 99297, 99303, 99313, 99314, 99316, 99319, 99321, 99322, 99392, 99413, 99476, 99477, 99478, 99483, 99488, 99489, 99490, 99491, 99492, 99557, 99588, 99589, 99590, 99591, 99628, 99650, 99673, 99698, 99699, 99700, 99701, 99702, 99703, 99708, 99711, 99714, 99715, 99716, 99723, 99724) AND `item_rank` <> 3 | 1 | 1 | 10 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6173) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h144-033445'))))) OR (((`item_id2` = 6173) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h144-033445'))))) OR (((`item_id3` = 6173) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h144-033445')))))) 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` = 6173 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` = 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` = 74432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-033445FC'))))) OR (((`item_id2` = 74432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-033445FC'))))) OR (((`item_id3` = 74432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-033445FC')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 74432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94281) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-289446'))))) OR (((`item_id2` = 94281) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-289446'))))) OR (((`item_id3` = 94281) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-289446')))))) 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` = 94281 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79023) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G8'))))) OR (((`item_id2` = 79023) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G8'))))) OR (((`item_id3` = 79023) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G8')))))) 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` = 79023 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84906) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2711971'))))) OR (((`item_id2` = 84906) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2711971'))))) OR (((`item_id3` = 84906) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2711971')))))) 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` = 84906 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85156) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1061-006'))))) OR (((`item_id2` = 85156) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1061-006'))))) OR (((`item_id3` = 85156) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1061-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 85156 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 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` = 84313) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-238444'))))) OR (((`item_id2` = 84313) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-238444'))))) OR (((`item_id3` = 84313) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-238444')))))) 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` = 84313 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94546) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1816-009'))))) OR (((`item_id2` = 94546) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1816-009'))))) OR (((`item_id3` = 94546) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1816-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` = 94546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6775) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041747'))))) OR (((`item_id2` = 6775) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041747'))))) OR (((`item_id3` = 6775) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041747')))))) 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` = 6775 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74242) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0490AB'))))) OR (((`item_id2` = 74242) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0490AB'))))) OR (((`item_id3` = 74242) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0490AB')))))) 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` = 74242 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` = 6516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-N0001'))))) OR (((`item_id2` = 6516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-N0001'))))) OR (((`item_id3` = 6516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-N0001')))))) 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` = 6516 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 | |