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 '%PE%') OR (`Item`.`item_name` Like '%PE%') OR (`Item`.`item_figure` Like '%PE%') OR (`Item`.`item_color` Like '%PE%') OR (`Item`.`item_materials` Like '%PE%') OR (`Item`.`item_note` Like '%PE%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1134 | 1134 | 181 | 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`.`item_rank` = 1 AND `Item`.`id` IN (35638, 35639, 35640, 35651, 35652, 35665, 48175, 48176, 57706, 57707, 57708, 57709, 64448, 64470, 64472, 64476, 65198, 65199, 65209, 65209, 65329, 65331, 65331, 65337, 65338, 65338, 70489, 73029, 73030, 73031, 73052, 73052, 73062, 73062, 73154, 73154, 73176, 73176, 73527, 73527, 73528, 73528, 73613, 73614, 73642, 73650, 73650, 73651, 73651, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 77070, 77072, 77073, 77074, 77083, 77083, 77096, 77141, 77213, 77214, 77215, 77216, 77225, 77225, 77584, 77604, 77604, 77604, 77610, 77611, 77662, 77663, 77755, 77755, 79265, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80804, 80804, 81215, 81216, 81216, 81229, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81506, 81506, 81509, 81509, 81510, 81510, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 82963, 83160, 83161, 83532, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 84173, 84218, 84356, 84357, 84358, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84521, 84522, 84523, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84538, 84539, 84539, 84540, 84541, 84542, 84544, 84545, 85010, 85010, 85011, 85011, 85017, 85017, 85017, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85218, 85219, 85443, 85505, 85530, 85636, 85637, 85638, 85639, 85640, 85641, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85722, 85723, 85723, 86096, 86339, 86421, 87115, 87252, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 87376, 87377, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87400, 87401, 87402, 87405, 87406, 87448, 87702, 87702, 87702, 87820, 87821, 87822, 87844, 87845, 87851, 87851, 87851, 87852, 87856, 87856, 87857, 87858, 87859, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 88204, 88205, 88206, 88207, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88283, 88283, 88396, 88884, 88885, 88886, 88887, 89286, 89312, 89489, 89497, 89539, 89996, 90021, 90319, 90368, 90369, 90408, 90409, 90410, 90457, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90745, 90745, 90746, 90746, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91011, 91012, 91115, 91117, 91320, 91321, 91322, 91322, 91387, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91481, 91487, 91586, 91586, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91650, 91651, 91652, 91653, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91674, 91675, 91783, 91785, 92499, 92500, 92540, 92549, 92640, 92669, 92670, 92675, 92829, 92840, 92841, 92842, 92847, 92901, 92906, 92907, 92933, 92988, 93007, 93008, 93012, 93051, 93058, 93129, 93183, 93226, 93232, 93245, 93246, 93261, 93371, 93600, 93608, 93933, 93938, 93938, 93955, 93985, 94279, 94282, 94283, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94342, 94342, 94344, 94360, 94361, 94364, 94370, 94371, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94459, 94460, 94461, 94462, 94497, 94498, 94498, 94499, 94500, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94509, 94510, 94511, 94512, 94513, 94514, 94515, 94516, 94517, 94518, 94519, 94520, 94521, 94555, 94556, 94557, 94558, 94571, 94572, 94595, 94595, 94596, 94596, 94598, 94598, 94599, 94599, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94761, 94831, 94861, 94861, 94862, 94862, 95087, 95135, 95135, 95136, 95136, 95156, 95158, 95159, 95163, 95166, 95167, 95168, 95169, 95181, 95185, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95245, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95347, 95348, 95349, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95569, 95570, 95571, 95572, 95573, 95618, 95619, 95620, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95656, 95657, 95658, 95659, 95660, 95661, 95743, 95767, 95770, 95777, 95780, 95784, 95784, 95791, 95792, 95793, 95893, 95924, 95925, 95926, 95929, 95930, 95931, 95932, 95933, 95934, 95939, 95951, 96329, 96336, 96338, 96345, 96379, 96381, 96386, 96402, 96410, 96411, 96412, 96413, 96445, 96467, 96475, 96476, 96477, 96478, 96590, 96593, 96641, 96666, 96667, 96668, 96755, 96756, 96763, 96765, 96766, 96768, 96769, 96812, 96814, 96817, 96818, 96819, 96822, 96881, 96960, 96968, 97376, 97378, 97388, 97609, 97617, 97618, 97618, 97619, 97619, 97690, 97691, 97692, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97793, 97797, 97798, 97811, 97840, 97841, 97842, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98119, 98119, 98120, 98127, 98153, 98167, 98169, 98169, 98177, 98177, 98181, 98221, 98221, 98222, 98222, 98223, 98434, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98651, 98654, 98655, 98656, 98667, 98679, 98680, 98681, 98687, 98705, 98706, 98707, 98712, 98731, 98732, 98733, 98734, 98752, 98783, 98806, 98811, 98813, 98814, 98815, 98816, 98817, 98820, 98821, 98822, 98848, 98905, 98926, 98928, 98929, 98930, 98943, 98953, 98954, 98974, 98975, 98976, 99015, 99016, 99017, 99271, 99282, 99287, 99288, 99289, 99290, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99413, 99444, 99456, 99458, 99472, 99473, 99474, 99475, 99549, 99550, 99672, 99730, 99734, 99735, 99741, 99742, 99743, 99744, 99745, 99747, 99748, 99752, 99753, 99754, 99755, 99756) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 4 | 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`.`item_rank` = 1 AND `Item`.`id` IN (35638, 35639, 35640, 35651, 35652, 35665, 48175, 48176, 57706, 57707, 57708, 57709, 64448, 64470, 64472, 64476, 65198, 65199, 65209, 65209, 65329, 65331, 65331, 65337, 65338, 65338, 70489, 73029, 73030, 73031, 73052, 73052, 73062, 73062, 73154, 73154, 73176, 73176, 73527, 73527, 73528, 73528, 73613, 73614, 73642, 73650, 73650, 73651, 73651, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 77070, 77072, 77073, 77074, 77083, 77083, 77096, 77141, 77213, 77214, 77215, 77216, 77225, 77225, 77584, 77604, 77604, 77604, 77610, 77611, 77662, 77663, 77755, 77755, 79265, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80804, 80804, 81215, 81216, 81216, 81229, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81506, 81506, 81509, 81509, 81510, 81510, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 82963, 83160, 83161, 83532, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 84173, 84218, 84356, 84357, 84358, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84521, 84522, 84523, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84538, 84539, 84539, 84540, 84541, 84542, 84544, 84545, 85010, 85010, 85011, 85011, 85017, 85017, 85017, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85218, 85219, 85443, 85505, 85530, 85636, 85637, 85638, 85639, 85640, 85641, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85722, 85723, 85723, 86096, 86339, 86421, 87115, 87252, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 87376, 87377, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87400, 87401, 87402, 87405, 87406, 87448, 87702, 87702, 87702, 87820, 87821, 87822, 87844, 87845, 87851, 87851, 87851, 87852, 87856, 87856, 87857, 87858, 87859, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 88204, 88205, 88206, 88207, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88283, 88283, 88396, 88884, 88885, 88886, 88887, 89286, 89312, 89489, 89497, 89539, 89996, 90021, 90319, 90368, 90369, 90408, 90409, 90410, 90457, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90745, 90745, 90746, 90746, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91011, 91012, 91115, 91117, 91320, 91321, 91322, 91322, 91387, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91481, 91487, 91586, 91586, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91650, 91651, 91652, 91653, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91674, 91675, 91783, 91785, 92499, 92500, 92540, 92549, 92640, 92669, 92670, 92675, 92829, 92840, 92841, 92842, 92847, 92901, 92906, 92907, 92933, 92988, 93007, 93008, 93012, 93051, 93058, 93129, 93183, 93226, 93232, 93245, 93246, 93261, 93371, 93600, 93608, 93933, 93938, 93938, 93955, 93985, 94279, 94282, 94283, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94342, 94342, 94344, 94360, 94361, 94364, 94370, 94371, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94459, 94460, 94461, 94462, 94497, 94498, 94498, 94499, 94500, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94509, 94510, 94511, 94512, 94513, 94514, 94515, 94516, 94517, 94518, 94519, 94520, 94521, 94555, 94556, 94557, 94558, 94571, 94572, 94595, 94595, 94596, 94596, 94598, 94598, 94599, 94599, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94761, 94831, 94861, 94861, 94862, 94862, 95087, 95135, 95135, 95136, 95136, 95156, 95158, 95159, 95163, 95166, 95167, 95168, 95169, 95181, 95185, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95245, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95347, 95348, 95349, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95569, 95570, 95571, 95572, 95573, 95618, 95619, 95620, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95656, 95657, 95658, 95659, 95660, 95661, 95743, 95767, 95770, 95777, 95780, 95784, 95784, 95791, 95792, 95793, 95893, 95924, 95925, 95926, 95929, 95930, 95931, 95932, 95933, 95934, 95939, 95951, 96329, 96336, 96338, 96345, 96379, 96381, 96386, 96402, 96410, 96411, 96412, 96413, 96445, 96467, 96475, 96476, 96477, 96478, 96590, 96593, 96641, 96666, 96667, 96668, 96755, 96756, 96763, 96765, 96766, 96768, 96769, 96812, 96814, 96817, 96818, 96819, 96822, 96881, 96960, 96968, 97376, 97378, 97388, 97609, 97617, 97618, 97618, 97619, 97619, 97690, 97691, 97692, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97793, 97797, 97798, 97811, 97840, 97841, 97842, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98119, 98119, 98120, 98127, 98153, 98167, 98169, 98169, 98177, 98177, 98181, 98221, 98221, 98222, 98222, 98223, 98434, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98651, 98654, 98655, 98656, 98667, 98679, 98680, 98681, 98687, 98705, 98706, 98707, 98712, 98731, 98732, 98733, 98734, 98752, 98783, 98806, 98811, 98813, 98814, 98815, 98816, 98817, 98820, 98821, 98822, 98848, 98905, 98926, 98928, 98929, 98930, 98943, 98953, 98954, 98974, 98975, 98976, 99015, 99016, 99017, 99271, 99282, 99287, 99288, 99289, 99290, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99413, 99444, 99456, 99458, 99472, 99473, 99474, 99475, 99549, 99550, 99672, 99730, 99734, 99735, 99741, 99742, 99743, 99744, 99745, 99747, 99748, 99752, 99753, 99754, 99755, 99756) AND `item_rank` <> 3 | 1 | 1 | 3 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1824-044'))))) OR (((`item_id2` = 94652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1824-044'))))) OR (((`item_id3` = 94652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1824-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 94652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95893) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2533G12'))))) OR (((`item_id2` = 95893) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2533G12'))))) OR (((`item_id3` = 95893) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2533G12')))))) 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` = 95893 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1843-044'))))) OR (((`item_id2` = 94599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1843-044'))))) OR (((`item_id3` = 94599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1843-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 94599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 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` = 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` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-006')))))) 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` = 98609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98620) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-034'))))) OR (((`item_id2` = 98620) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-034'))))) OR (((`item_id3` = 98620) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-034')))))) 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` = 98620 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98619) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-009'))))) OR (((`item_id2` = 98619) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-009'))))) OR (((`item_id3` = 98619) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-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` = 98619 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98618) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1372-006'))))) OR (((`item_id2` = 98618) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1372-006'))))) OR (((`item_id3` = 98618) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1372-006')))))) 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` = 98618 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98617) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-034'))))) OR (((`item_id2` = 98617) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-034'))))) OR (((`item_id3` = 98617) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-034')))))) 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` = 98617 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-009'))))) OR (((`item_id2` = 98616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-009'))))) OR (((`item_id3` = 98616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-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` = 98616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95167) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35720'))))) OR (((`item_id2` = 95167) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35720'))))) OR (((`item_id3` = 95167) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35720')))))) 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` = 95167 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1371-006'))))) OR (((`item_id2` = 98615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1371-006'))))) OR (((`item_id3` = 98615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1371-006')))))) 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` = 98615 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98614) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1370-034'))))) OR (((`item_id2` = 98614) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1370-034'))))) OR (((`item_id3` = 98614) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1370-034')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98614 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98613) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1370-009'))))) OR (((`item_id2` = 98613) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1370-009'))))) OR (((`item_id3` = 98613) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1370-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` = 98613 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 | |