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 | 1730 | 1730 | 209 | 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 (6173, 6272, 6272, 6273, 6273, 6274, 6274, 6775, 6776, 6778, 6778, 6779, 6779, 34936, 34936, 35016, 35017, 35134, 35135, 35157, 35161, 35416, 35417, 35420, 35447, 35448, 35449, 35450, 35528, 35536, 35537, 35555, 35556, 35624, 35625, 35626, 35638, 35639, 35640, 35651, 35652, 35665, 35673, 35674, 35675, 35676, 35692, 35693, 35695, 35696, 35699, 36334, 38489, 38489, 38504, 38504, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 44781, 44781, 45501, 48175, 48176, 54080, 54082, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 57632, 57644, 57645, 57706, 57707, 57708, 57709, 57714, 57715, 57765, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 58178, 58222, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64556, 64556, 64557, 64557, 64618, 64618, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 65033, 65033, 65198, 65199, 65202, 65203, 65209, 65209, 65212, 65213, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 65296, 65297, 65297, 65298, 65329, 65331, 65331, 65334, 65335, 65337, 65338, 65338, 65720, 65721, 65722, 65739, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 73678, 73678, 73678, 73719, 73720, 73727, 73730, 73731, 73734, 73734, 73737, 73737, 73747, 73747, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73820, 73864, 73864, 73866, 73870, 73870, 73871, 74432, 74439, 74440, 74753, 74753, 74753, 74754, 74754, 74754, 74764, 74765, 74766, 74767, 74768, 74768, 74769, 74769, 76890, 77075, 77213, 77214, 77215, 77216, 77219, 77220, 77225, 77225, 77226, 77227, 77228, 77229, 77230, 77230, 77230, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77590, 77590, 77601, 77604, 77604, 77604, 77610, 77611, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77634, 77635, 77636, 77637, 77662, 77663, 77668, 77668, 77669, 77670, 77683, 77684, 77685, 77686, 77695, 77696, 77697, 77698, 77699, 77699, 77700, 77700, 77700, 78134, 80646, 80646, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80734, 80735, 80736, 80737, 80742, 80743, 80744, 80745, 80748, 80752, 80804, 80804, 80805, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81506, 81507, 81508, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81552, 81553, 81554, 81555, 81556, 81558, 83584, 83752, 83780, 83781, 83782, 83783, 83784, 83785, 83787, 83788, 83789, 83790, 83791, 83792, 83792, 83793, 83800, 83801, 83802, 83804, 83804, 83805, 83806, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83828, 83829, 83830, 83831, 83873, 83874, 83875, 83877, 83877, 83877, 83878, 83878, 83878, 83936, 83978, 83979, 83980, 83981, 84100, 84286, 84313, 84313, 84314, 84314, 84315, 84315, 84343, 84343, 84344, 84344, 84345, 84345, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 84421, 84421, 84468, 84469, 84470, 84471, 84472, 84473, 84474, 84475, 84476, 84477, 84478, 84479, 84482, 84482, 84483, 84483, 84484, 84485, 84486, 84487, 84488, 84489, 84490, 84491, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 84514, 84515, 84516, 84517, 84518, 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, 84591, 84592, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84930, 84996, 84997, 85010, 85010, 85011, 85011, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85202, 85208, 85208, 85209, 85209, 85210, 85211, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85412, 85531, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85704, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85717, 85718, 85719, 85720, 85721, 85798, 87115, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87315, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87382, 87382, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87633, 87634, 87820, 87821, 87822, 87823, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87852, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 88176, 88177, 88178, 88179, 88180, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88249, 88250, 88251, 88252, 88253, 88254, 88396, 88497, 88498, 88499, 88537, 88537, 89075, 89089, 89117, 89140, 89188, 89292, 89316, 89511, 89616, 90103, 90104, 90231, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90411, 90412, 90413, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90440, 90441, 90442, 90443, 90457, 90461, 90461, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90754, 90755, 90756, 90757, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 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, 91003, 91003, 91003, 91004, 91004, 91004, 91007, 91008, 91011, 91012, 91013, 91027, 91028, 91037, 91074, 91115, 91117, 91336, 91388, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91481, 91483, 91485, 91488, 91511, 91512, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91650, 91651, 91652, 91653, 91654, 91655, 91656, 91657, 91658, 91659, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91674, 91675, 91752, 91752, 91975, 91976, 91998, 92052, 92114, 92496, 92497, 92500, 92511, 92513, 92514, 92515, 92516, 92517, 92518, 92519, 92520, 92522, 92523, 92524, 92535, 92536, 92538, 92539, 92547, 92548, 92549, 92550, 92551, 92552, 92553, 92609, 92619, 92823, 92925, 93054, 93171, 93189, 93211, 93213, 93241, 93492, 93598, 93599, 93631, 93636, 93955, 93982, 94364, 94427, 94427, 94427, 94428, 94428, 94428, 94429, 94429, 94429, 94430, 94430, 94430, 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, 94493, 94495, 94496, 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, 94546, 94547, 94548, 94549, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94831, 94867, 94868, 94869, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95162, 95162, 95185, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95377, 95421, 95422, 95423, 95424, 95425, 95426, 95427, 95428, 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, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95595, 95596, 95597, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95656, 95657, 95744, 95803, 95804, 95805, 95911, 95912, 95913, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95973, 95974, 96014, 96015, 96036, 96037, 96038, 96186, 96187, 96188, 96189, 96197, 96198, 96199, 96204, 96209, 96306, 96316, 96320, 96337, 96340, 96341, 96344, 96345, 96377, 96402, 96403, 96404, 96406, 96409, 96425, 96469, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96657, 96660, 96749, 96751, 96757, 96758, 96761, 96792, 96794, 96812, 96859, 96869, 96882, 96883, 97047, 97056, 97059, 97063, 97379, 97383, 97383, 97623, 97624, 97789, 97792, 97805, 97825, 97840, 97841, 97842, 97971, 97972, 97973, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 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, 98163, 98171, 98183, 98185, 98414, 98422, 98422, 98453, 98472, 98489, 98490, 98491, 98492, 98492, 98493, 98493, 98522, 98523, 98524, 98529, 98530, 98531, 98532, 98533, 98534, 98535, 98536, 98626, 98664, 98665, 98668, 98669, 98691, 98692, 98698, 98718, 98719, 98745, 98753, 98754, 98781, 98782, 98805, 98806, 98848, 98908, 98909, 98922, 98962, 99298, 99299, 99317, 99340, 99341, 99342, 99343, 99353, 99370, 99391, 99459, 99460, 99461, 99462, 99506, 99508, 99509, 99510, 99550, 99558, 99559, 99580, 99581, 99582, 99650, 99651, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99679, 99751) 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 (6173, 6272, 6272, 6273, 6273, 6274, 6274, 6775, 6776, 6778, 6778, 6779, 6779, 34936, 34936, 35016, 35017, 35134, 35135, 35157, 35161, 35416, 35417, 35420, 35447, 35448, 35449, 35450, 35528, 35536, 35537, 35555, 35556, 35624, 35625, 35626, 35638, 35639, 35640, 35651, 35652, 35665, 35673, 35674, 35675, 35676, 35692, 35693, 35695, 35696, 35699, 36334, 38489, 38489, 38504, 38504, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 44781, 44781, 45501, 48175, 48176, 54080, 54082, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 57632, 57644, 57645, 57706, 57707, 57708, 57709, 57714, 57715, 57765, 58154, 58155, 58155, 58156, 58156, 58157, 58158, 58178, 58222, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64556, 64556, 64557, 64557, 64618, 64618, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 65033, 65033, 65198, 65199, 65202, 65203, 65209, 65209, 65212, 65213, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 65296, 65297, 65297, 65298, 65329, 65331, 65331, 65334, 65335, 65337, 65338, 65338, 65720, 65721, 65722, 65739, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73052, 73052, 73056, 73062, 73062, 73276, 73276, 73678, 73678, 73678, 73719, 73720, 73727, 73730, 73731, 73734, 73734, 73737, 73737, 73747, 73747, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73820, 73864, 73864, 73866, 73870, 73870, 73871, 74432, 74439, 74440, 74753, 74753, 74753, 74754, 74754, 74754, 74764, 74765, 74766, 74767, 74768, 74768, 74769, 74769, 76890, 77075, 77213, 77214, 77215, 77216, 77219, 77220, 77225, 77225, 77226, 77227, 77228, 77229, 77230, 77230, 77230, 77244, 77245, 77245, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77590, 77590, 77601, 77604, 77604, 77604, 77610, 77611, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77634, 77635, 77636, 77637, 77662, 77663, 77668, 77668, 77669, 77670, 77683, 77684, 77685, 77686, 77695, 77696, 77697, 77698, 77699, 77699, 77700, 77700, 77700, 78134, 80646, 80646, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80734, 80735, 80736, 80737, 80742, 80743, 80744, 80745, 80748, 80752, 80804, 80804, 80805, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81506, 81507, 81508, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81552, 81553, 81554, 81555, 81556, 81558, 83584, 83752, 83780, 83781, 83782, 83783, 83784, 83785, 83787, 83788, 83789, 83790, 83791, 83792, 83792, 83793, 83800, 83801, 83802, 83804, 83804, 83805, 83806, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83828, 83829, 83830, 83831, 83873, 83874, 83875, 83877, 83877, 83877, 83878, 83878, 83878, 83936, 83978, 83979, 83980, 83981, 84100, 84286, 84313, 84313, 84314, 84314, 84315, 84315, 84343, 84343, 84344, 84344, 84345, 84345, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 84421, 84421, 84468, 84469, 84470, 84471, 84472, 84473, 84474, 84475, 84476, 84477, 84478, 84479, 84482, 84482, 84483, 84483, 84484, 84485, 84486, 84487, 84488, 84489, 84490, 84491, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 84514, 84515, 84516, 84517, 84518, 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, 84591, 84592, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84930, 84996, 84997, 85010, 85010, 85011, 85011, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85202, 85208, 85208, 85209, 85209, 85210, 85211, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85412, 85531, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85704, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85717, 85718, 85719, 85720, 85721, 85798, 87115, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87315, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87382, 87382, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87633, 87634, 87820, 87821, 87822, 87823, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87852, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87906, 87907, 87908, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 88176, 88177, 88178, 88179, 88180, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88249, 88250, 88251, 88252, 88253, 88254, 88396, 88497, 88498, 88499, 88537, 88537, 89075, 89089, 89117, 89140, 89188, 89292, 89316, 89511, 89616, 90103, 90104, 90231, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90411, 90412, 90413, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90440, 90441, 90442, 90443, 90457, 90461, 90461, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90754, 90755, 90756, 90757, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 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, 91003, 91003, 91003, 91004, 91004, 91004, 91007, 91008, 91011, 91012, 91013, 91027, 91028, 91037, 91074, 91115, 91117, 91336, 91388, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91481, 91483, 91485, 91488, 91511, 91512, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91648, 91649, 91650, 91651, 91652, 91653, 91654, 91655, 91656, 91657, 91658, 91659, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91674, 91675, 91752, 91752, 91975, 91976, 91998, 92052, 92114, 92496, 92497, 92500, 92511, 92513, 92514, 92515, 92516, 92517, 92518, 92519, 92520, 92522, 92523, 92524, 92535, 92536, 92538, 92539, 92547, 92548, 92549, 92550, 92551, 92552, 92553, 92609, 92619, 92823, 92925, 93054, 93171, 93189, 93211, 93213, 93241, 93492, 93598, 93599, 93631, 93636, 93955, 93982, 94364, 94427, 94427, 94427, 94428, 94428, 94428, 94429, 94429, 94429, 94430, 94430, 94430, 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, 94493, 94495, 94496, 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, 94546, 94547, 94548, 94549, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94831, 94867, 94868, 94869, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95162, 95162, 95185, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95377, 95421, 95422, 95423, 95424, 95425, 95426, 95427, 95428, 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, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95595, 95596, 95597, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95656, 95657, 95744, 95803, 95804, 95805, 95911, 95912, 95913, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95964, 95965, 95966, 95967, 95968, 95969, 95970, 95971, 95972, 95973, 95974, 96014, 96015, 96036, 96037, 96038, 96186, 96187, 96188, 96189, 96197, 96198, 96199, 96204, 96209, 96306, 96316, 96320, 96337, 96340, 96341, 96344, 96345, 96377, 96402, 96403, 96404, 96406, 96409, 96425, 96469, 96625, 96626, 96627, 96628, 96629, 96630, 96631, 96632, 96633, 96657, 96660, 96749, 96751, 96757, 96758, 96761, 96792, 96794, 96812, 96859, 96869, 96882, 96883, 97047, 97056, 97059, 97063, 97379, 97383, 97383, 97623, 97624, 97789, 97792, 97805, 97825, 97840, 97841, 97842, 97971, 97972, 97973, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 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, 98163, 98171, 98183, 98185, 98414, 98422, 98422, 98453, 98472, 98489, 98490, 98491, 98492, 98492, 98493, 98493, 98522, 98523, 98524, 98529, 98530, 98531, 98532, 98533, 98534, 98535, 98536, 98626, 98664, 98665, 98668, 98669, 98691, 98692, 98698, 98718, 98719, 98745, 98753, 98754, 98781, 98782, 98805, 98806, 98848, 98908, 98909, 98922, 98962, 99298, 99299, 99317, 99340, 99341, 99342, 99343, 99353, 99370, 99391, 99459, 99460, 99461, 99462, 99506, 99508, 99509, 99510, 99550, 99558, 99559, 99580, 99581, 99582, 99650, 99651, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99679, 99751) AND `item_rank` <> 3 | 1 | 1 | 4 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54080) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0991-009'))))) OR (((`item_id2` = 54080) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0991-009'))))) OR (((`item_id3` = 54080) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0991-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 54080 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 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 | 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` = 92517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95575) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1883-044'))))) OR (((`item_id2` = 95575) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1883-044'))))) OR (((`item_id3` = 95575) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1883-044')))))) 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` = 95575 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 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` = 96197) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25261G9A'))))) OR (((`item_id2` = 96197) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25261G9A'))))) OR (((`item_id3` = 96197) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25261G9A')))))) 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` = 96197 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` = 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 | 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` = 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` = 93213) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25304G10'))))) OR (((`item_id2` = 93213) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25304G10'))))) OR (((`item_id3` = 93213) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25304G10')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 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` = 93213 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35699) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0453-008'))))) OR (((`item_id2` = 35699) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0453-008'))))) OR (((`item_id3` = 35699) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0453-008')))))) 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` = 35699 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-002'))))) OR (((`item_id2` = 77246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-002'))))) OR (((`item_id3` = 77246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-002')))))) 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` = 77246 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 | |