Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_name` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_figure` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_color` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_materials` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_note` Like '%[アウトドア/レジャー]%') OR (`Item`.`item_code` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_name` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_figure` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_color` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_materials` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_note` Like '%折りたたみコンパクトレジャーチェア%') OR (`Item`.`item_code` Like '%ブラック%') OR (`Item`.`item_name` Like '%ブラック%') OR (`Item`.`item_figure` Like '%ブラック%') OR (`Item`.`item_color` Like '%ブラック%') OR (`Item`.`item_materials` Like '%ブラック%') OR (`Item`.`item_note` Like '%ブラック%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1433 | 1433 | 365 | 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 (34834, 34834, 34865, 34875, 34909, 34960, 34962, 34965, 34969, 34969, 34972, 34981, 35016, 35018, 35026, 35026, 35059, 35059, 35135, 35157, 35164, 35170, 35179, 35180, 35188, 35189, 35190, 35193, 35210, 35230, 35232, 35244, 35252, 35254, 35262, 35264, 35289, 35298, 35307, 35389, 35417, 35447, 35449, 35523, 35537, 35556, 35562, 35568, 35574, 35574, 35579, 35579, 35626, 35640, 35651, 35652, 35674, 35693, 35695, 35725, 35725, 35786, 35786, 44694, 44700, 44701, 44707, 44762, 44762, 44764, 44785, 44786, 44787, 44788, 54080, 54082, 54086, 54086, 54090, 57632, 57645, 57650, 57650, 57651, 57651, 57652, 57652, 57697, 57715, 57733, 57747, 57748, 57764, 57765, 58131, 58136, 58136, 58143, 58143, 58158, 58215, 58230, 58236, 64430, 64595, 64606, 64630, 64630, 64631, 64631, 64638, 64638, 64651, 64654, 64658, 64662, 64665, 64671, 64671, 65198, 65213, 65220, 65220, 65222, 65222, 65233, 65251, 65269, 65282, 65282, 65329, 65334, 65809, 68101, 68275, 69675, 69846, 73657, 73665, 73666, 73667, 73667, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73730, 73763, 73763, 73764, 73766, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73805, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73825, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 73864, 73864, 73866, 73870, 73870, 73871, 75298, 76107, 77072, 77143, 77147, 77151, 77163, 77165, 77167, 77167, 77169, 77169, 77213, 77215, 77217, 77219, 77230, 77230, 77230, 77245, 77245, 77248, 77253, 77255, 77255, 77319, 77610, 77615, 77615, 77616, 77616, 77631, 77631, 77634, 77644, 77644, 77647, 77650, 77653, 77655, 77655, 77662, 77670, 77683, 77695, 77697, 77699, 77699, 77700, 77700, 77700, 77708, 77713, 77718, 77723, 80584, 80588, 80596, 80609, 80609, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 80646, 80646, 80649, 80657, 80662, 80664, 80666, 80666, 80670, 80674, 80674, 80679, 80681, 80683, 80687, 80704, 80704, 80711, 80711, 80715, 80715, 80725, 80725, 80729, 80735, 80737, 80744, 80761, 80765, 80786, 80796, 80799, 81472, 81472, 81474, 81474, 81478, 81481, 81483, 81496, 81502, 81504, 81508, 81512, 81515, 81518, 81522, 81522, 81526, 81530, 81530, 81534, 81538, 81542, 81542, 81545, 81545, 81550, 81552, 81555, 81570, 81570, 81572, 81572, 81574, 81578, 81578, 81582, 81586, 81591, 81591, 81596, 81599, 81604, 81614, 81614, 81616, 81616, 81622, 81622, 81625, 81629, 81635, 82455, 82495, 83385, 83754, 83754, 83758, 83758, 83758, 83780, 83782, 83785, 83788, 83790, 83792, 83792, 83801, 83809, 83812, 83813, 83815, 83815, 83819, 83824, 83829, 83831, 83837, 83840, 83842, 83845, 83851, 83862, 83867, 83873, 83874, 83875, 83878, 83878, 83878, 83886, 83890, 83893, 83896, 83899, 83899, 83902, 83938, 83938, 84423, 84423, 84427, 84427, 84443, 84445, 84449, 84449, 84451, 84457, 84461, 84465, 84469, 84471, 84472, 84474, 84483, 84483, 84485, 84489, 84494, 84494, 84497, 84502, 84508, 84511, 84514, 84520, 84522, 84528, 84531, 84533, 84533, 84535, 84535, 84538, 84542, 84553, 84555, 84558, 84564, 84566, 84569, 84569, 84574, 84577, 84577, 84580, 84580, 84581, 84582, 84585, 84585, 84598, 84598, 84606, 84606, 84611, 84613, 84906, 84907, 84930, 84987, 84993, 84995, 84996, 85001, 85003, 85019, 85022, 85034, 85036, 85041, 85041, 85043, 85046, 85046, 85050, 85052, 85063, 85065, 85065, 85068, 85070, 85070, 85073, 85078, 85083, 85088, 85092, 85092, 85105, 85105, 85110, 85122, 85122, 85125, 85125, 85131, 85131, 85134, 85134, 85137, 85141, 85149, 85149, 85155, 85158, 85161, 85163, 85166, 85169, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85209, 85209, 85212, 85214, 85214, 85216, 85219, 85220, 85220, 85223, 85444, 85530, 85534, 85539, 85634, 85634, 85637, 85640, 85658, 85663, 85665, 85665, 85667, 85669, 85671, 85677, 85680, 85683, 85697, 85697, 85699, 85699, 85709, 85709, 85711, 85711, 85713, 85713, 85715, 85715, 85717, 85719, 86013, 86013, 86028, 86033, 86070, 86078, 86079, 86097, 86109, 86744, 86833, 87302, 87302, 87304, 87304, 87308, 87308, 87312, 87312, 87315, 87328, 87333, 87333, 87337, 87337, 87337, 87342, 87347, 87358, 87358, 87362, 87362, 87362, 87365, 87365, 87368, 87368, 87371, 87374, 87374, 87376, 87378, 87383, 87383, 87385, 87385, 87388, 87391, 87391, 87396, 87398, 87400, 87403, 87405, 87407, 87410, 87411, 87448, 87809, 87813, 87821, 87822, 87845, 87854, 87857, 87859, 87861, 87861, 87863, 87863, 87865, 87865, 87886, 87886, 87886, 87888, 87888, 87888, 87890, 87891, 87892, 87897, 87901, 87906, 87909, 87911, 87913, 87913, 87913, 87915, 87915, 87944, 87944, 87944, 87946, 87946, 88150, 88184, 88184, 88189, 88189, 88191, 88192, 88195, 88200, 88203, 88205, 88207, 88209, 88209, 88215, 88216, 88217, 88218, 88220, 88222, 88225, 88231, 88231, 88233, 88233, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88251, 88253, 88453, 88460, 88594, 88644, 88861, 88972, 89011, 89745, 90325, 90326, 90326, 90361, 90365, 90368, 90371, 90373, 90375, 90377, 90379, 90381, 90383, 90385, 90387, 90389, 90401, 90403, 90406, 90410, 90416, 90419, 90419, 90422, 90422, 90425, 90425, 90428, 90429, 90429, 90432, 90434, 90436, 90449, 90450, 90462, 90683, 90683, 90685, 90689, 90689, 90691, 90706, 90718, 90741, 90745, 90745, 90751, 90751, 90751, 90759, 90762, 90765, 90767, 90771, 90771, 90775, 90779, 90783, 90787, 90791, 90795, 90799, 90803, 90807, 90811, 90821, 90828, 90835, 90842, 90849, 90856, 90857, 90861, 90865, 90869, 90873, 90877, 90881, 90885, 90890, 90891, 90894, 90898, 90902, 90941, 90941, 90946, 90946, 90967, 90973, 90978, 90983, 90988, 90998, 91006, 91007, 91015, 91015, 91017, 91020, 91020, 91023, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91393, 91395, 91400, 91405, 91410, 91414, 91418, 91423, 91428, 91433, 91438, 91442, 91447, 91451, 91454, 91457, 91460, 91463, 91466, 91469, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91495, 91500, 91541, 91589, 91589, 91589, 91613, 91615, 91617, 91617, 91620, 91620, 91645, 91648, 91650, 91655, 91659, 91660, 91665, 91667, 91671, 91674, 91679, 91679, 91682, 91682, 91685, 91685, 91688, 91688, 91691, 91691, 91694, 91694, 91697, 91697, 91700, 91700, 91703, 91703, 91706, 91706, 91709, 91709, 91754, 91841, 91877, 91897, 91923, 91929, 91941, 92022, 92186, 92192, 92331, 92371, 92382, 92389, 92396, 92443, 92444, 92446, 92447, 92449, 92450, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92697, 92724, 92730, 92777, 93533, 93949, 94357, 94376, 94376, 94382, 94387, 94392, 94428, 94428, 94428, 94430, 94430, 94430, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94450, 94454, 94459, 94523, 94527, 94531, 94535, 94539, 94543, 94546, 94548, 94565, 94568, 94577, 94581, 94584, 94588, 94592, 94597, 94597, 94598, 94598, 94600, 94600, 94607, 94608, 94609, 94610, 94611, 94612, 94614, 94616, 94619, 94626, 94631, 94638, 94642, 94647, 94654, 94657, 94659, 94666, 94669, 94673, 94696, 94699, 94705, 94708, 94721, 94726, 94726, 94726, 94728, 94728, 94728, 94730, 94730, 94730, 94743, 94745, 94826, 94831, 94844, 94847, 94859, 94861, 94861, 94863, 94867, 95058, 95130, 95135, 95135, 95137, 95137, 95166, 95167, 95168, 95169, 95170, 95174, 95178, 95179, 95191, 95191, 95196, 95201, 95206, 95209, 95212, 95215, 95218, 95221, 95224, 95227, 95230, 95232, 95234, 95236, 95247, 95249, 95251, 95253, 95276, 95281, 95299, 95303, 95311, 95311, 95315, 95319, 95324, 95326, 95331, 95336, 95361, 95362, 95434, 95438, 95442, 95446, 95450, 95454, 95458, 95460, 95462, 95465, 95468, 95473, 95476, 95483, 95487, 95491, 95495, 95499, 95503, 95505, 95512, 95514, 95516, 95518, 95520, 95522, 95525, 95527, 95529, 95543, 95548, 95551, 95553, 95572, 95581, 95590, 95594, 95597, 95607, 95622, 95627, 95630, 95644, 95647, 95652, 95654, 95656, 95657, 95658, 95668, 95672, 95685, 95692, 95699, 95706, 95716, 95727, 95735, 95763, 95764, 95765, 95766, 95767, 95768, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95820, 95863, 95868, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 95975, 95981, 95984, 96000, 96164, 96178, 96184, 96189, 96194, 96197, 96387, 96403, 96440, 96469, 96478, 96485, 96494, 96596, 96659, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 96838, 96839, 96851, 96854, 96893, 96897, 96901, 96950, 97146, 97162, 97362, 97368, 97368, 97369, 97646, 97650, 97665, 97720, 97720, 97722, 97729, 97736, 97743, 97750, 97757, 97764, 97771, 97778, 97796, 97809, 97810, 97841, 97857, 97863, 97878, 97908, 97913, 97918, 97923, 97923, 97928, 97928, 97933, 97938, 97943, 97943, 97947, 97952, 97986, 97986, 97994, 97994, 97999, 98005, 98011, 98015, 98023, 98031, 98044, 98044, 98051, 98051, 98051, 98053, 98053, 98053, 98056, 98056, 98056, 98071, 98075, 98077, 98079, 98080, 98081, 98082, 98083, 98084, 98087, 98091, 98095, 98099, 98106, 98121, 98122, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98158, 98427, 98434, 98437, 98437, 98490, 98492, 98492, 98496, 98510, 98510, 98515, 98515, 98517, 98518, 98519, 98520, 98521, 98524, 98527, 98538, 98543, 98548, 98553, 98557, 98561, 98565, 98569, 98573, 98577, 98582, 98586, 98590, 98590, 98595, 98601, 98606, 98610, 98613, 98616, 98619, 98622, 98623, 98624, 98625, 98642, 98643, 98644, 98645, 98646, 98698, 98718, 98734, 98782, 98791, 98862, 98891, 98901, 98911, 98915, 98945, 98947, 98967, 98969, 98971, 98976, 98977, 98994, 99001, 99006, 99008, 99011, 99023, 99026, 99030, 99041, 99044, 99046, 99051, 99053, 99059, 99068, 99073, 99172, 99188, 99293, 99295, 99330, 99336, 99338, 99343, 99365, 99366, 99390, 99396, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426, 99435, 99461, 99471, 99499, 99501, 99536, 99537, 99579, 99633, 99637, 99752, 99755, 99757, 99759, 99766, 99768, 99772, 99776, 99780) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 9 | 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 (34834, 34834, 34865, 34875, 34909, 34960, 34962, 34965, 34969, 34969, 34972, 34981, 35016, 35018, 35026, 35026, 35059, 35059, 35135, 35157, 35164, 35170, 35179, 35180, 35188, 35189, 35190, 35193, 35210, 35230, 35232, 35244, 35252, 35254, 35262, 35264, 35289, 35298, 35307, 35389, 35417, 35447, 35449, 35523, 35537, 35556, 35562, 35568, 35574, 35574, 35579, 35579, 35626, 35640, 35651, 35652, 35674, 35693, 35695, 35725, 35725, 35786, 35786, 44694, 44700, 44701, 44707, 44762, 44762, 44764, 44785, 44786, 44787, 44788, 54080, 54082, 54086, 54086, 54090, 57632, 57645, 57650, 57650, 57651, 57651, 57652, 57652, 57697, 57715, 57733, 57747, 57748, 57764, 57765, 58131, 58136, 58136, 58143, 58143, 58158, 58215, 58230, 58236, 64430, 64595, 64606, 64630, 64630, 64631, 64631, 64638, 64638, 64651, 64654, 64658, 64662, 64665, 64671, 64671, 65198, 65213, 65220, 65220, 65222, 65222, 65233, 65251, 65269, 65282, 65282, 65329, 65334, 65809, 68101, 68275, 69675, 69846, 73657, 73665, 73666, 73667, 73667, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73730, 73763, 73763, 73764, 73766, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73805, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73825, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 73864, 73864, 73866, 73870, 73870, 73871, 75298, 76107, 77072, 77143, 77147, 77151, 77163, 77165, 77167, 77167, 77169, 77169, 77213, 77215, 77217, 77219, 77230, 77230, 77230, 77245, 77245, 77248, 77253, 77255, 77255, 77319, 77610, 77615, 77615, 77616, 77616, 77631, 77631, 77634, 77644, 77644, 77647, 77650, 77653, 77655, 77655, 77662, 77670, 77683, 77695, 77697, 77699, 77699, 77700, 77700, 77700, 77708, 77713, 77718, 77723, 80584, 80588, 80596, 80609, 80609, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 80646, 80646, 80649, 80657, 80662, 80664, 80666, 80666, 80670, 80674, 80674, 80679, 80681, 80683, 80687, 80704, 80704, 80711, 80711, 80715, 80715, 80725, 80725, 80729, 80735, 80737, 80744, 80761, 80765, 80786, 80796, 80799, 81472, 81472, 81474, 81474, 81478, 81481, 81483, 81496, 81502, 81504, 81508, 81512, 81515, 81518, 81522, 81522, 81526, 81530, 81530, 81534, 81538, 81542, 81542, 81545, 81545, 81550, 81552, 81555, 81570, 81570, 81572, 81572, 81574, 81578, 81578, 81582, 81586, 81591, 81591, 81596, 81599, 81604, 81614, 81614, 81616, 81616, 81622, 81622, 81625, 81629, 81635, 82455, 82495, 83385, 83754, 83754, 83758, 83758, 83758, 83780, 83782, 83785, 83788, 83790, 83792, 83792, 83801, 83809, 83812, 83813, 83815, 83815, 83819, 83824, 83829, 83831, 83837, 83840, 83842, 83845, 83851, 83862, 83867, 83873, 83874, 83875, 83878, 83878, 83878, 83886, 83890, 83893, 83896, 83899, 83899, 83902, 83938, 83938, 84423, 84423, 84427, 84427, 84443, 84445, 84449, 84449, 84451, 84457, 84461, 84465, 84469, 84471, 84472, 84474, 84483, 84483, 84485, 84489, 84494, 84494, 84497, 84502, 84508, 84511, 84514, 84520, 84522, 84528, 84531, 84533, 84533, 84535, 84535, 84538, 84542, 84553, 84555, 84558, 84564, 84566, 84569, 84569, 84574, 84577, 84577, 84580, 84580, 84581, 84582, 84585, 84585, 84598, 84598, 84606, 84606, 84611, 84613, 84906, 84907, 84930, 84987, 84993, 84995, 84996, 85001, 85003, 85019, 85022, 85034, 85036, 85041, 85041, 85043, 85046, 85046, 85050, 85052, 85063, 85065, 85065, 85068, 85070, 85070, 85073, 85078, 85083, 85088, 85092, 85092, 85105, 85105, 85110, 85122, 85122, 85125, 85125, 85131, 85131, 85134, 85134, 85137, 85141, 85149, 85149, 85155, 85158, 85161, 85163, 85166, 85169, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85209, 85209, 85212, 85214, 85214, 85216, 85219, 85220, 85220, 85223, 85444, 85530, 85534, 85539, 85634, 85634, 85637, 85640, 85658, 85663, 85665, 85665, 85667, 85669, 85671, 85677, 85680, 85683, 85697, 85697, 85699, 85699, 85709, 85709, 85711, 85711, 85713, 85713, 85715, 85715, 85717, 85719, 86013, 86013, 86028, 86033, 86070, 86078, 86079, 86097, 86109, 86744, 86833, 87302, 87302, 87304, 87304, 87308, 87308, 87312, 87312, 87315, 87328, 87333, 87333, 87337, 87337, 87337, 87342, 87347, 87358, 87358, 87362, 87362, 87362, 87365, 87365, 87368, 87368, 87371, 87374, 87374, 87376, 87378, 87383, 87383, 87385, 87385, 87388, 87391, 87391, 87396, 87398, 87400, 87403, 87405, 87407, 87410, 87411, 87448, 87809, 87813, 87821, 87822, 87845, 87854, 87857, 87859, 87861, 87861, 87863, 87863, 87865, 87865, 87886, 87886, 87886, 87888, 87888, 87888, 87890, 87891, 87892, 87897, 87901, 87906, 87909, 87911, 87913, 87913, 87913, 87915, 87915, 87944, 87944, 87944, 87946, 87946, 88150, 88184, 88184, 88189, 88189, 88191, 88192, 88195, 88200, 88203, 88205, 88207, 88209, 88209, 88215, 88216, 88217, 88218, 88220, 88222, 88225, 88231, 88231, 88233, 88233, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88251, 88253, 88453, 88460, 88594, 88644, 88861, 88972, 89011, 89745, 90325, 90326, 90326, 90361, 90365, 90368, 90371, 90373, 90375, 90377, 90379, 90381, 90383, 90385, 90387, 90389, 90401, 90403, 90406, 90410, 90416, 90419, 90419, 90422, 90422, 90425, 90425, 90428, 90429, 90429, 90432, 90434, 90436, 90449, 90450, 90462, 90683, 90683, 90685, 90689, 90689, 90691, 90706, 90718, 90741, 90745, 90745, 90751, 90751, 90751, 90759, 90762, 90765, 90767, 90771, 90771, 90775, 90779, 90783, 90787, 90791, 90795, 90799, 90803, 90807, 90811, 90821, 90828, 90835, 90842, 90849, 90856, 90857, 90861, 90865, 90869, 90873, 90877, 90881, 90885, 90890, 90891, 90894, 90898, 90902, 90941, 90941, 90946, 90946, 90967, 90973, 90978, 90983, 90988, 90998, 91006, 91007, 91015, 91015, 91017, 91020, 91020, 91023, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91393, 91395, 91400, 91405, 91410, 91414, 91418, 91423, 91428, 91433, 91438, 91442, 91447, 91451, 91454, 91457, 91460, 91463, 91466, 91469, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91495, 91500, 91541, 91589, 91589, 91589, 91613, 91615, 91617, 91617, 91620, 91620, 91645, 91648, 91650, 91655, 91659, 91660, 91665, 91667, 91671, 91674, 91679, 91679, 91682, 91682, 91685, 91685, 91688, 91688, 91691, 91691, 91694, 91694, 91697, 91697, 91700, 91700, 91703, 91703, 91706, 91706, 91709, 91709, 91754, 91841, 91877, 91897, 91923, 91929, 91941, 92022, 92186, 92192, 92331, 92371, 92382, 92389, 92396, 92443, 92444, 92446, 92447, 92449, 92450, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92697, 92724, 92730, 92777, 93533, 93949, 94357, 94376, 94376, 94382, 94387, 94392, 94428, 94428, 94428, 94430, 94430, 94430, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94450, 94454, 94459, 94523, 94527, 94531, 94535, 94539, 94543, 94546, 94548, 94565, 94568, 94577, 94581, 94584, 94588, 94592, 94597, 94597, 94598, 94598, 94600, 94600, 94607, 94608, 94609, 94610, 94611, 94612, 94614, 94616, 94619, 94626, 94631, 94638, 94642, 94647, 94654, 94657, 94659, 94666, 94669, 94673, 94696, 94699, 94705, 94708, 94721, 94726, 94726, 94726, 94728, 94728, 94728, 94730, 94730, 94730, 94743, 94745, 94826, 94831, 94844, 94847, 94859, 94861, 94861, 94863, 94867, 95058, 95130, 95135, 95135, 95137, 95137, 95166, 95167, 95168, 95169, 95170, 95174, 95178, 95179, 95191, 95191, 95196, 95201, 95206, 95209, 95212, 95215, 95218, 95221, 95224, 95227, 95230, 95232, 95234, 95236, 95247, 95249, 95251, 95253, 95276, 95281, 95299, 95303, 95311, 95311, 95315, 95319, 95324, 95326, 95331, 95336, 95361, 95362, 95434, 95438, 95442, 95446, 95450, 95454, 95458, 95460, 95462, 95465, 95468, 95473, 95476, 95483, 95487, 95491, 95495, 95499, 95503, 95505, 95512, 95514, 95516, 95518, 95520, 95522, 95525, 95527, 95529, 95543, 95548, 95551, 95553, 95572, 95581, 95590, 95594, 95597, 95607, 95622, 95627, 95630, 95644, 95647, 95652, 95654, 95656, 95657, 95658, 95668, 95672, 95685, 95692, 95699, 95706, 95716, 95727, 95735, 95763, 95764, 95765, 95766, 95767, 95768, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95820, 95863, 95868, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 95975, 95981, 95984, 96000, 96164, 96178, 96184, 96189, 96194, 96197, 96387, 96403, 96440, 96469, 96478, 96485, 96494, 96596, 96659, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 96838, 96839, 96851, 96854, 96893, 96897, 96901, 96950, 97146, 97162, 97362, 97368, 97368, 97369, 97646, 97650, 97665, 97720, 97720, 97722, 97729, 97736, 97743, 97750, 97757, 97764, 97771, 97778, 97796, 97809, 97810, 97841, 97857, 97863, 97878, 97908, 97913, 97918, 97923, 97923, 97928, 97928, 97933, 97938, 97943, 97943, 97947, 97952, 97986, 97986, 97994, 97994, 97999, 98005, 98011, 98015, 98023, 98031, 98044, 98044, 98051, 98051, 98051, 98053, 98053, 98053, 98056, 98056, 98056, 98071, 98075, 98077, 98079, 98080, 98081, 98082, 98083, 98084, 98087, 98091, 98095, 98099, 98106, 98121, 98122, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98158, 98427, 98434, 98437, 98437, 98490, 98492, 98492, 98496, 98510, 98510, 98515, 98515, 98517, 98518, 98519, 98520, 98521, 98524, 98527, 98538, 98543, 98548, 98553, 98557, 98561, 98565, 98569, 98573, 98577, 98582, 98586, 98590, 98590, 98595, 98601, 98606, 98610, 98613, 98616, 98619, 98622, 98623, 98624, 98625, 98642, 98643, 98644, 98645, 98646, 98698, 98718, 98734, 98782, 98791, 98862, 98891, 98901, 98911, 98915, 98945, 98947, 98967, 98969, 98971, 98976, 98977, 98994, 99001, 99006, 99008, 99011, 99023, 99026, 99030, 99041, 99044, 99046, 99051, 99053, 99059, 99068, 99073, 99172, 99188, 99293, 99295, 99330, 99336, 99338, 99343, 99365, 99366, 99390, 99396, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426, 99435, 99461, 99471, 99499, 99501, 99536, 99537, 99579, 99633, 99637, 99752, 99755, 99757, 99759, 99766, 99768, 99772, 99776, 99780) 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` = 91476) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1779-044'))))) OR (((`item_id2` = 91476) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1779-044'))))) OR (((`item_id3` = 91476) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1779-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` = 91476 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 82495) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G3B'))))) OR (((`item_id2` = 82495) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G3B'))))) OR (((`item_id3` = 82495) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G3B')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 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` = 82495 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 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` = 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` = 95362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325070'))))) OR (((`item_id2` = 95362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325070'))))) OR (((`item_id3` = 95362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325070')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95362 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35170) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-009'))))) OR (((`item_id2` = 35170) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-009'))))) OR (((`item_id3` = 35170) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 35170 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94745) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2373861'))))) OR (((`item_id2` = 94745) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2373861'))))) OR (((`item_id3` = 94745) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2373861')))))) 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` = 94745 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846261'))))) OR (((`item_id2` = 95607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846261'))))) OR (((`item_id3` = 95607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846261')))))) 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` = 95607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91941) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25312G7A'))))) OR (((`item_id2` = 91941) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25312G7A'))))) OR (((`item_id3` = 91941) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25312G7A')))))) 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` = 91941 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 | 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` = 84906 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81625) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0952-009'))))) OR (((`item_id2` = 81625) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0952-009'))))) OR (((`item_id3` = 81625) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0952-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` = 81625 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-009'))))) OR (((`item_id2` = 87383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-009'))))) OR (((`item_id3` = 87383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87383 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 | 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` = 94546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64665) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0737-009'))))) OR (((`item_id2` = 64665) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0737-009'))))) OR (((`item_id3` = 64665) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0737-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` = 64665 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95311) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0122-009'))))) OR (((`item_id2` = 95311) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0122-009'))))) OR (((`item_id3` = 95311) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0122-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` = 95311 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 | |