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 '%アイボリー%') 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 | 1666 | 1666 | 503 | 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 (6030, 6030, 6031, 6031, 6059, 6064, 6164, 6173, 6176, 6177, 6272, 6272, 6273, 6273, 6274, 6274, 6776, 6779, 6779, 12380, 12965, 12999, 13000, 29179, 29241, 34886, 34961, 34963, 34968, 34971, 34971, 34974, 34983, 35017, 35161, 35163, 35166, 35169, 35192, 35198, 35209, 35231, 35233, 35260, 35261, 35263, 35269, 35270, 35271, 35274, 35294, 35303, 35312, 35388, 35420, 35448, 35450, 35593, 35624, 35676, 35692, 35699, 35726, 35726, 36770, 38489, 38489, 38504, 38504, 44760, 44760, 44761, 44761, 44763, 44781, 44781, 44785, 44786, 44787, 44788, 45144, 45144, 45501, 54036, 54043, 54050, 54050, 54057, 54069, 54083, 54083, 54087, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57685, 57685, 57706, 57707, 58134, 58134, 58154, 58215, 58222, 58324, 58348, 58348, 58355, 58355, 64430, 64438, 64445, 64445, 64446, 64446, 64447, 64447, 64618, 64618, 64622, 64623, 64624, 64630, 64630, 64631, 64631, 64637, 64637, 64647, 64660, 64676, 64686, 65033, 65033, 65199, 65209, 65209, 65212, 65278, 65337, 65358, 65366, 65373, 65374, 65739, 68349, 71886, 71888, 72448, 72448, 73527, 73527, 73528, 73528, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73731, 73747, 73747, 73763, 73763, 73764, 73766, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73850, 73851, 73864, 73864, 73866, 73870, 73870, 73871, 74424, 74424, 74427, 74428, 74432, 74440, 74445, 74445, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74779, 74780, 74782, 74782, 74787, 74788, 75677, 76890, 77039, 77075, 77081, 77096, 77141, 77142, 77146, 77150, 77162, 77164, 77166, 77166, 77202, 77203, 77214, 77216, 77220, 77226, 77228, 77244, 77245, 77245, 77249, 77254, 77254, 77270, 77271, 77315, 77316, 77584, 77611, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77642, 77642, 77645, 77648, 77651, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77705, 77705, 77707, 77712, 77717, 77722, 77755, 77755, 78017, 78018, 78019, 78053, 78054, 78058, 78066, 78084, 78085, 78144, 78159, 78417, 80550, 80587, 80595, 80598, 80611, 80611, 80646, 80646, 80648, 80653, 80658, 80663, 80665, 80669, 80673, 80673, 80678, 80680, 80682, 80686, 80730, 80734, 80735, 80736, 80737, 80745, 80760, 80764, 80781, 80787, 80798, 80811, 80813, 81216, 81216, 81229, 81471, 81471, 81473, 81477, 81480, 81484, 81497, 81501, 81503, 81507, 81511, 81514, 81517, 81521, 81521, 81528, 81528, 81532, 81532, 81540, 81540, 81551, 81553, 81556, 81558, 81585, 81590, 81590, 81595, 81598, 81603, 81608, 81609, 81610, 81621, 81621, 81624, 81628, 81636, 81671, 81721, 81722, 81723, 82070, 82080, 82456, 82499, 82515, 82516, 82517, 82968, 83781, 83783, 83784, 83787, 83791, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83818, 83823, 83828, 83830, 83861, 83866, 83877, 83877, 83877, 83885, 83888, 83891, 83894, 83897, 83900, 83903, 83921, 83921, 83975, 83976, 83978, 83979, 83980, 83981, 84174, 84263, 84314, 84314, 84318, 84318, 84322, 84322, 84328, 84328, 84352, 84355, 84358, 84442, 84444, 84453, 84454, 84455, 84456, 84460, 84464, 84468, 84470, 84476, 84477, 84478, 84480, 84480, 84482, 84482, 84484, 84485, 84486, 84487, 84488, 84493, 84493, 84496, 84501, 84506, 84507, 84517, 84521, 84530, 84534, 84534, 84536, 84536, 84537, 84541, 84557, 84561, 84567, 84572, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84591, 84592, 84593, 84593, 84612, 84616, 84620, 84908, 84984, 84984, 84984, 84997, 85010, 85010, 85012, 85012, 85015, 85015, 85017, 85017, 85017, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85035, 85039, 85039, 85042, 85045, 85048, 85051, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85139, 85164, 85165, 85171, 85171, 85183, 85183, 85208, 85208, 85210, 85211, 85213, 85215, 85215, 85217, 85218, 85222, 85288, 85290, 85333, 85334, 85342, 85443, 85445, 85455, 85458, 85459, 85460, 85461, 85462, 85464, 85491, 85530, 85537, 85538, 85642, 85643, 85644, 85645, 85662, 85664, 85664, 85666, 85668, 85670, 85672, 85673, 85674, 85675, 85678, 85681, 85684, 85684, 85694, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85703, 85703, 85710, 85712, 85712, 85716, 85716, 85718, 85720, 85729, 85729, 85814, 86012, 86012, 86049, 86070, 86285, 86583, 86743, 87271, 87287, 87287, 87303, 87303, 87307, 87307, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87373, 87375, 87375, 87377, 87379, 87384, 87384, 87387, 87387, 87390, 87393, 87393, 87394, 87395, 87397, 87399, 87401, 87404, 87406, 87413, 87414, 87414, 87414, 87664, 87758, 87759, 87760, 87776, 87783, 87784, 87785, 87786, 87809, 87844, 87851, 87851, 87851, 87852, 87860, 87860, 87862, 87862, 87864, 87864, 87898, 87902, 87907, 87910, 87912, 87914, 87914, 87914, 87916, 87916, 87925, 87935, 88141, 88142, 88143, 88180, 88183, 88183, 88188, 88188, 88191, 88194, 88197, 88204, 88206, 88211, 88212, 88213, 88214, 88216, 88219, 88228, 88228, 88229, 88229, 88230, 88230, 88232, 88232, 88234, 88234, 88235, 88235, 88279, 88283, 88283, 88864, 89011, 89578, 89580, 89660, 89745, 89746, 90102, 90103, 90104, 90364, 90369, 90370, 90372, 90374, 90376, 90378, 90380, 90382, 90384, 90386, 90388, 90390, 90391, 90392, 90393, 90394, 90398, 90399, 90400, 90402, 90405, 90410, 90411, 90412, 90413, 90414, 90414, 90417, 90418, 90418, 90421, 90421, 90424, 90424, 90430, 90430, 90431, 90432, 90433, 90438, 90674, 90678, 90688, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90750, 90750, 90750, 90758, 90761, 90764, 90815, 90816, 90822, 90823, 90829, 90830, 90836, 90837, 90843, 90844, 90850, 90851, 90889, 90936, 90936, 90939, 90944, 90944, 90949, 90949, 90951, 90954, 90961, 90962, 90964, 90965, 90966, 90972, 90977, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90996, 90997, 91001, 91001, 91002, 91005, 91008, 91009, 91010, 91011, 91012, 91013, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91022, 91028, 91029, 91030, 91031, 91032, 91120, 91120, 91320, 91321, 91328, 91328, 91394, 91402, 91407, 91420, 91424, 91425, 91429, 91430, 91434, 91435, 91439, 91444, 91449, 91476, 91481, 91487, 91490, 91493, 91507, 91507, 91540, 91587, 91587, 91587, 91590, 91590, 91590, 91608, 91609, 91610, 91611, 91612, 91614, 91643, 91644, 91646, 91647, 91649, 91653, 91654, 91657, 91664, 91666, 91675, 91676, 91677, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 91718, 91718, 91719, 91739, 91739, 91749, 91754, 91829, 91830, 91840, 91844, 91859, 91891, 91896, 91947, 91957, 92048, 92091, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92324, 92330, 92357, 92370, 92381, 92389, 92390, 92391, 92497, 92547, 92698, 92703, 92725, 92729, 92730, 92731, 92732, 92766, 92776, 92827, 92828, 92907, 92922, 92978, 93055, 93171, 93241, 93265, 93276, 93286, 93300, 93301, 93348, 93400, 93532, 93607, 93658, 93681, 93698, 93699, 93729, 93791, 93794, 93800, 93802, 93804, 93811, 93820, 93885, 93899, 94253, 94253, 94269, 94270, 94272, 94273, 94274, 94275, 94276, 94279, 94280, 94281, 94282, 94318, 94318, 94319, 94319, 94324, 94396, 94397, 94398, 94427, 94427, 94427, 94429, 94429, 94429, 94436, 94437, 94438, 94447, 94451, 94458, 94462, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94550, 94551, 94553, 94555, 94556, 94557, 94558, 94560, 94561, 94562, 94563, 94564, 94566, 94569, 94572, 94574, 94575, 94579, 94583, 94587, 94591, 94599, 94599, 94602, 94602, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94661, 94665, 94668, 94674, 94704, 94707, 94709, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94749, 94751, 94751, 94760, 94762, 94764, 94827, 94827, 94849, 94851, 94860, 94862, 94862, 95054, 95057, 95063, 95134, 95136, 95136, 95138, 95138, 95194, 95194, 95199, 95204, 95205, 95207, 95210, 95213, 95216, 95219, 95222, 95225, 95228, 95231, 95233, 95235, 95248, 95250, 95252, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95270, 95272, 95274, 95279, 95284, 95301, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95337, 95338, 95339, 95340, 95343, 95347, 95348, 95349, 95418, 95419, 95420, 95421, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95463, 95466, 95469, 95506, 95513, 95515, 95517, 95519, 95521, 95523, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95579, 95580, 95581, 95582, 95583, 95584, 95587, 95591, 95606, 95615, 95626, 95627, 95628, 95633, 95637, 95641, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95788, 95800, 95803, 95804, 95805, 95821, 95853, 95856, 95899, 95997, 96014, 96037, 96038, 96039, 96097, 96098, 96107, 96112, 96113, 96117, 96126, 96127, 96129, 96133, 96149, 96167, 96193, 96195, 96198, 96224, 96229, 96230, 96231, 96275, 96337, 96388, 96404, 96432, 96491, 96492, 96493, 96494, 96495, 96496, 96497, 96498, 96504, 96509, 96514, 96531, 96532, 96533, 96534, 96661, 96684, 96740, 96751, 96757, 96758, 96811, 96823, 96833, 96837, 96853, 96862, 96868, 96894, 96898, 96945, 96970, 97020, 97021, 97022, 97035, 97038, 97060, 97068, 97069, 97106, 97121, 97122, 97123, 97151, 97155, 97158, 97162, 97175, 97209, 97210, 97211, 97212, 97213, 97215, 97216, 97217, 97218, 97219, 97238, 97239, 97240, 97242, 97272, 97276, 97279, 97288, 97291, 97292, 97310, 97314, 97332, 97333, 97335, 97339, 97341, 97344, 97378, 97387, 97394, 97605, 97606, 97609, 97612, 97613, 97614, 97615, 97615, 97616, 97616, 97617, 97618, 97618, 97619, 97619, 97626, 97627, 97628, 97629, 97647, 97651, 97655, 97659, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97686, 97687, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97721, 97721, 97725, 97728, 97735, 97742, 97749, 97756, 97763, 97770, 97777, 97790, 97792, 97805, 97808, 97828, 97840, 97843, 97844, 97856, 97862, 97877, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97949, 97954, 97982, 97985, 97985, 97993, 97993, 97997, 98004, 98012, 98019, 98021, 98029, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98070, 98073, 98076, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98090, 98094, 98098, 98103, 98129, 98130, 98131, 98157, 98159, 98189, 98216, 98217, 98429, 98432, 98491, 98493, 98493, 98502, 98503, 98504, 98505, 98506, 98511, 98511, 98516, 98516, 98521, 98523, 98528, 98530, 98532, 98533, 98534, 98535, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98594, 98600, 98621, 98627, 98629, 98630, 98632, 98657, 98664, 98669, 98701, 98705, 98712, 98719, 98723, 98736, 98759, 98810, 98835, 98861, 98863, 98865, 98866, 98881, 98890, 98891, 98892, 98900, 98910, 98923, 98944, 98949, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99003, 99007, 99010, 99015, 99016, 99021, 99024, 99037, 99044, 99045, 99052, 99061, 99064, 99072, 99077, 99147, 99179, 99200, 99201, 99202, 99215, 99216, 99217, 99224, 99225, 99226, 99240, 99251, 99255, 99256, 99259, 99261, 99268, 99270, 99272, 99273, 99278, 99286, 99303, 99323, 99334, 99362, 99364, 99379, 99385, 99387, 99391, 99404, 99436, 99444, 99473, 99498, 99500, 99514, 99515, 99516, 99524, 99526, 99527, 99528, 99529, 99542, 99552, 99555, 99560, 99562, 99592, 99594, 99596, 99597, 99622, 99623, 99649, 99652, 99674, 99693, 99694, 99695, 99731) 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`.`item_rank` = 1 AND `Item`.`id` IN (6030, 6030, 6031, 6031, 6059, 6064, 6164, 6173, 6176, 6177, 6272, 6272, 6273, 6273, 6274, 6274, 6776, 6779, 6779, 12380, 12965, 12999, 13000, 29179, 29241, 34886, 34961, 34963, 34968, 34971, 34971, 34974, 34983, 35017, 35161, 35163, 35166, 35169, 35192, 35198, 35209, 35231, 35233, 35260, 35261, 35263, 35269, 35270, 35271, 35274, 35294, 35303, 35312, 35388, 35420, 35448, 35450, 35593, 35624, 35676, 35692, 35699, 35726, 35726, 36770, 38489, 38489, 38504, 38504, 44760, 44760, 44761, 44761, 44763, 44781, 44781, 44785, 44786, 44787, 44788, 45144, 45144, 45501, 54036, 54043, 54050, 54050, 54057, 54069, 54083, 54083, 54087, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57685, 57685, 57706, 57707, 58134, 58134, 58154, 58215, 58222, 58324, 58348, 58348, 58355, 58355, 64430, 64438, 64445, 64445, 64446, 64446, 64447, 64447, 64618, 64618, 64622, 64623, 64624, 64630, 64630, 64631, 64631, 64637, 64637, 64647, 64660, 64676, 64686, 65033, 65033, 65199, 65209, 65209, 65212, 65278, 65337, 65358, 65366, 65373, 65374, 65739, 68349, 71886, 71888, 72448, 72448, 73527, 73527, 73528, 73528, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73731, 73747, 73747, 73763, 73763, 73764, 73766, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73850, 73851, 73864, 73864, 73866, 73870, 73870, 73871, 74424, 74424, 74427, 74428, 74432, 74440, 74445, 74445, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74779, 74780, 74782, 74782, 74787, 74788, 75677, 76890, 77039, 77075, 77081, 77096, 77141, 77142, 77146, 77150, 77162, 77164, 77166, 77166, 77202, 77203, 77214, 77216, 77220, 77226, 77228, 77244, 77245, 77245, 77249, 77254, 77254, 77270, 77271, 77315, 77316, 77584, 77611, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77642, 77642, 77645, 77648, 77651, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77705, 77705, 77707, 77712, 77717, 77722, 77755, 77755, 78017, 78018, 78019, 78053, 78054, 78058, 78066, 78084, 78085, 78144, 78159, 78417, 80550, 80587, 80595, 80598, 80611, 80611, 80646, 80646, 80648, 80653, 80658, 80663, 80665, 80669, 80673, 80673, 80678, 80680, 80682, 80686, 80730, 80734, 80735, 80736, 80737, 80745, 80760, 80764, 80781, 80787, 80798, 80811, 80813, 81216, 81216, 81229, 81471, 81471, 81473, 81477, 81480, 81484, 81497, 81501, 81503, 81507, 81511, 81514, 81517, 81521, 81521, 81528, 81528, 81532, 81532, 81540, 81540, 81551, 81553, 81556, 81558, 81585, 81590, 81590, 81595, 81598, 81603, 81608, 81609, 81610, 81621, 81621, 81624, 81628, 81636, 81671, 81721, 81722, 81723, 82070, 82080, 82456, 82499, 82515, 82516, 82517, 82968, 83781, 83783, 83784, 83787, 83791, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83818, 83823, 83828, 83830, 83861, 83866, 83877, 83877, 83877, 83885, 83888, 83891, 83894, 83897, 83900, 83903, 83921, 83921, 83975, 83976, 83978, 83979, 83980, 83981, 84174, 84263, 84314, 84314, 84318, 84318, 84322, 84322, 84328, 84328, 84352, 84355, 84358, 84442, 84444, 84453, 84454, 84455, 84456, 84460, 84464, 84468, 84470, 84476, 84477, 84478, 84480, 84480, 84482, 84482, 84484, 84485, 84486, 84487, 84488, 84493, 84493, 84496, 84501, 84506, 84507, 84517, 84521, 84530, 84534, 84534, 84536, 84536, 84537, 84541, 84557, 84561, 84567, 84572, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84591, 84592, 84593, 84593, 84612, 84616, 84620, 84908, 84984, 84984, 84984, 84997, 85010, 85010, 85012, 85012, 85015, 85015, 85017, 85017, 85017, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85035, 85039, 85039, 85042, 85045, 85048, 85051, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85139, 85164, 85165, 85171, 85171, 85183, 85183, 85208, 85208, 85210, 85211, 85213, 85215, 85215, 85217, 85218, 85222, 85288, 85290, 85333, 85334, 85342, 85443, 85445, 85455, 85458, 85459, 85460, 85461, 85462, 85464, 85491, 85530, 85537, 85538, 85642, 85643, 85644, 85645, 85662, 85664, 85664, 85666, 85668, 85670, 85672, 85673, 85674, 85675, 85678, 85681, 85684, 85684, 85694, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85703, 85703, 85710, 85712, 85712, 85716, 85716, 85718, 85720, 85729, 85729, 85814, 86012, 86012, 86049, 86070, 86285, 86583, 86743, 87271, 87287, 87287, 87303, 87303, 87307, 87307, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87373, 87375, 87375, 87377, 87379, 87384, 87384, 87387, 87387, 87390, 87393, 87393, 87394, 87395, 87397, 87399, 87401, 87404, 87406, 87413, 87414, 87414, 87414, 87664, 87758, 87759, 87760, 87776, 87783, 87784, 87785, 87786, 87809, 87844, 87851, 87851, 87851, 87852, 87860, 87860, 87862, 87862, 87864, 87864, 87898, 87902, 87907, 87910, 87912, 87914, 87914, 87914, 87916, 87916, 87925, 87935, 88141, 88142, 88143, 88180, 88183, 88183, 88188, 88188, 88191, 88194, 88197, 88204, 88206, 88211, 88212, 88213, 88214, 88216, 88219, 88228, 88228, 88229, 88229, 88230, 88230, 88232, 88232, 88234, 88234, 88235, 88235, 88279, 88283, 88283, 88864, 89011, 89578, 89580, 89660, 89745, 89746, 90102, 90103, 90104, 90364, 90369, 90370, 90372, 90374, 90376, 90378, 90380, 90382, 90384, 90386, 90388, 90390, 90391, 90392, 90393, 90394, 90398, 90399, 90400, 90402, 90405, 90410, 90411, 90412, 90413, 90414, 90414, 90417, 90418, 90418, 90421, 90421, 90424, 90424, 90430, 90430, 90431, 90432, 90433, 90438, 90674, 90678, 90688, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90750, 90750, 90750, 90758, 90761, 90764, 90815, 90816, 90822, 90823, 90829, 90830, 90836, 90837, 90843, 90844, 90850, 90851, 90889, 90936, 90936, 90939, 90944, 90944, 90949, 90949, 90951, 90954, 90961, 90962, 90964, 90965, 90966, 90972, 90977, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90996, 90997, 91001, 91001, 91002, 91005, 91008, 91009, 91010, 91011, 91012, 91013, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91022, 91028, 91029, 91030, 91031, 91032, 91120, 91120, 91320, 91321, 91328, 91328, 91394, 91402, 91407, 91420, 91424, 91425, 91429, 91430, 91434, 91435, 91439, 91444, 91449, 91476, 91481, 91487, 91490, 91493, 91507, 91507, 91540, 91587, 91587, 91587, 91590, 91590, 91590, 91608, 91609, 91610, 91611, 91612, 91614, 91643, 91644, 91646, 91647, 91649, 91653, 91654, 91657, 91664, 91666, 91675, 91676, 91677, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 91718, 91718, 91719, 91739, 91739, 91749, 91754, 91829, 91830, 91840, 91844, 91859, 91891, 91896, 91947, 91957, 92048, 92091, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92324, 92330, 92357, 92370, 92381, 92389, 92390, 92391, 92497, 92547, 92698, 92703, 92725, 92729, 92730, 92731, 92732, 92766, 92776, 92827, 92828, 92907, 92922, 92978, 93055, 93171, 93241, 93265, 93276, 93286, 93300, 93301, 93348, 93400, 93532, 93607, 93658, 93681, 93698, 93699, 93729, 93791, 93794, 93800, 93802, 93804, 93811, 93820, 93885, 93899, 94253, 94253, 94269, 94270, 94272, 94273, 94274, 94275, 94276, 94279, 94280, 94281, 94282, 94318, 94318, 94319, 94319, 94324, 94396, 94397, 94398, 94427, 94427, 94427, 94429, 94429, 94429, 94436, 94437, 94438, 94447, 94451, 94458, 94462, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94550, 94551, 94553, 94555, 94556, 94557, 94558, 94560, 94561, 94562, 94563, 94564, 94566, 94569, 94572, 94574, 94575, 94579, 94583, 94587, 94591, 94599, 94599, 94602, 94602, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94661, 94665, 94668, 94674, 94704, 94707, 94709, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94749, 94751, 94751, 94760, 94762, 94764, 94827, 94827, 94849, 94851, 94860, 94862, 94862, 95054, 95057, 95063, 95134, 95136, 95136, 95138, 95138, 95194, 95194, 95199, 95204, 95205, 95207, 95210, 95213, 95216, 95219, 95222, 95225, 95228, 95231, 95233, 95235, 95248, 95250, 95252, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95270, 95272, 95274, 95279, 95284, 95301, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95337, 95338, 95339, 95340, 95343, 95347, 95348, 95349, 95418, 95419, 95420, 95421, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95463, 95466, 95469, 95506, 95513, 95515, 95517, 95519, 95521, 95523, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95579, 95580, 95581, 95582, 95583, 95584, 95587, 95591, 95606, 95615, 95626, 95627, 95628, 95633, 95637, 95641, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95788, 95800, 95803, 95804, 95805, 95821, 95853, 95856, 95899, 95997, 96014, 96037, 96038, 96039, 96097, 96098, 96107, 96112, 96113, 96117, 96126, 96127, 96129, 96133, 96149, 96167, 96193, 96195, 96198, 96224, 96229, 96230, 96231, 96275, 96337, 96388, 96404, 96432, 96491, 96492, 96493, 96494, 96495, 96496, 96497, 96498, 96504, 96509, 96514, 96531, 96532, 96533, 96534, 96661, 96684, 96740, 96751, 96757, 96758, 96811, 96823, 96833, 96837, 96853, 96862, 96868, 96894, 96898, 96945, 96970, 97020, 97021, 97022, 97035, 97038, 97060, 97068, 97069, 97106, 97121, 97122, 97123, 97151, 97155, 97158, 97162, 97175, 97209, 97210, 97211, 97212, 97213, 97215, 97216, 97217, 97218, 97219, 97238, 97239, 97240, 97242, 97272, 97276, 97279, 97288, 97291, 97292, 97310, 97314, 97332, 97333, 97335, 97339, 97341, 97344, 97378, 97387, 97394, 97605, 97606, 97609, 97612, 97613, 97614, 97615, 97615, 97616, 97616, 97617, 97618, 97618, 97619, 97619, 97626, 97627, 97628, 97629, 97647, 97651, 97655, 97659, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97686, 97687, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97721, 97721, 97725, 97728, 97735, 97742, 97749, 97756, 97763, 97770, 97777, 97790, 97792, 97805, 97808, 97828, 97840, 97843, 97844, 97856, 97862, 97877, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97949, 97954, 97982, 97985, 97985, 97993, 97993, 97997, 98004, 98012, 98019, 98021, 98029, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98070, 98073, 98076, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98090, 98094, 98098, 98103, 98129, 98130, 98131, 98157, 98159, 98189, 98216, 98217, 98429, 98432, 98491, 98493, 98493, 98502, 98503, 98504, 98505, 98506, 98511, 98511, 98516, 98516, 98521, 98523, 98528, 98530, 98532, 98533, 98534, 98535, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98594, 98600, 98621, 98627, 98629, 98630, 98632, 98657, 98664, 98669, 98701, 98705, 98712, 98719, 98723, 98736, 98759, 98810, 98835, 98861, 98863, 98865, 98866, 98881, 98890, 98891, 98892, 98900, 98910, 98923, 98944, 98949, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99003, 99007, 99010, 99015, 99016, 99021, 99024, 99037, 99044, 99045, 99052, 99061, 99064, 99072, 99077, 99147, 99179, 99200, 99201, 99202, 99215, 99216, 99217, 99224, 99225, 99226, 99240, 99251, 99255, 99256, 99259, 99261, 99268, 99270, 99272, 99273, 99278, 99286, 99303, 99323, 99334, 99362, 99364, 99379, 99385, 99387, 99391, 99404, 99436, 99444, 99473, 99498, 99500, 99514, 99515, 99516, 99524, 99526, 99527, 99528, 99529, 99542, 99552, 99555, 99560, 99562, 99592, 99594, 99596, 99597, 99622, 99623, 99649, 99652, 99674, 99693, 99694, 99695, 99731) 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` = 95429) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1318-044'))))) OR (((`item_id2` = 95429) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1318-044'))))) OR (((`item_id3` = 95429) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1318-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` = 95429 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` = 87935) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708911'))))) OR (((`item_id2` = 87935) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708911'))))) OR (((`item_id3` = 87935) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708911')))))) 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` = 87935 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 86049) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708551'))))) OR (((`item_id2` = 86049) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708551'))))) OR (((`item_id3` = 86049) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708551')))))) 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` = 86049 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 | 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` = 95575 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 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` = 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` = 35169) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-008'))))) OR (((`item_id2` = 35169) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-008'))))) OR (((`item_id3` = 35169) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-008')))))) 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` = 35169 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92209) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25323G3D'))))) OR (((`item_id2` = 92209) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25323G3D'))))) OR (((`item_id3` = 92209) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25323G3D')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 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` = 92209 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84984) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 's-wt1A-a'))))) OR (((`item_id2` = 84984) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 's-wt1A-a'))))) OR (((`item_id3` = 84984) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 's-wt1A-a')))))) 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` = 84984 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80811) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206443'))))) OR (((`item_id2` = 80811) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206443'))))) OR (((`item_id3` = 80811) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206443')))))) 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` = 80811 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94281) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-289446'))))) OR (((`item_id2` = 94281) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-289446'))))) OR (((`item_id3` = 94281) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-289446')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 94281 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84454) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1005-028'))))) OR (((`item_id2` = 84454) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1005-028'))))) OR (((`item_id3` = 84454) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1005-028')))))) 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` = 84454 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0962-028'))))) OR (((`item_id2` = 81609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0962-028'))))) OR (((`item_id3` = 81609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0962-028')))))) 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` = 81609 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 | |