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 '%ホワイト%') 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 | 2001 | 2001 | 567 | 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_speed` = 1 AND `Item`.`id` IN (6064, 6176, 6177, 12380, 34886, 34961, 34963, 34968, 34971, 34971, 34974, 34983, 35017, 35134, 35135, 35161, 35188, 35189, 35190, 35271, 35294, 35303, 35312, 35402, 35403, 35403, 35404, 35448, 35450, 35523, 35524, 35536, 35537, 35572, 35574, 35574, 35651, 35652, 35673, 35674, 35675, 35676, 35692, 35693, 35699, 35724, 35724, 35725, 35725, 35726, 35726, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 38504, 38504, 44694, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 44785, 44786, 44787, 44788, 45501, 54080, 54082, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57685, 57685, 57706, 57707, 57764, 57765, 58154, 58215, 58222, 64430, 64582, 64618, 64618, 64622, 64630, 64630, 64631, 64631, 64637, 64637, 64647, 64660, 64674, 65199, 65202, 65203, 65209, 65209, 65212, 65220, 65220, 65221, 65221, 65278, 65329, 65331, 65331, 65337, 65338, 65338, 65739, 65809, 70489, 71282, 72479, 72480, 73052, 73052, 73062, 73062, 73176, 73176, 73276, 73276, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73719, 73720, 73727, 73729, 73731, 73747, 73747, 73763, 73763, 73764, 73766, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73864, 73864, 73866, 73870, 73870, 73871, 74768, 74768, 74779, 74780, 74782, 74782, 76930, 76937, 77039, 77141, 77213, 77214, 77216, 77219, 77220, 77230, 77230, 77230, 77244, 77245, 77245, 77249, 77254, 77254, 77329, 77611, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77705, 77705, 77733, 77733, 77736, 77736, 78017, 78018, 78019, 78144, 79265, 79423, 80097, 80550, 80595, 80596, 80597, 80598, 80607, 80609, 80609, 80610, 80610, 80611, 80611, 80616, 80616, 80616, 80646, 80646, 80678, 80679, 80680, 80681, 80730, 80734, 80735, 80736, 80737, 80745, 80752, 80760, 80761, 80762, 80781, 80787, 81109, 81109, 81109, 81146, 81215, 81216, 81216, 81244, 81244, 81471, 81471, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81484, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81503, 81506, 81506, 81507, 81511, 81514, 81517, 81521, 81521, 81547, 81548, 81549, 81550, 81551, 81553, 81556, 81558, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81595, 81596, 81597, 81636, 82080, 82456, 82499, 82968, 83120, 83160, 83781, 83783, 83784, 83787, 83788, 83789, 83790, 83791, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83818, 83823, 83828, 83830, 83832, 83833, 83834, 83834, 83835, 83836, 83841, 83842, 83843, 83877, 83877, 83877, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83903, 83921, 83921, 83927, 84087, 84087, 84220, 84262, 84263, 84468, 84470, 84482, 84482, 84483, 84483, 84484, 84488, 84489, 84490, 84491, 84493, 84493, 84496, 84501, 84517, 84518, 84519, 84520, 84521, 84524, 84525, 84526, 84530, 84534, 84534, 84536, 84536, 84537, 84541, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84612, 84613, 84616, 84618, 84620, 84622, 84908, 84930, 84941, 84984, 84984, 84984, 84997, 85010, 85010, 85012, 85012, 85015, 85015, 85017, 85017, 85017, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85164, 85165, 85171, 85171, 85183, 85183, 85202, 85208, 85208, 85211, 85213, 85215, 85215, 85217, 85218, 85222, 85226, 85333, 85356, 85387, 85389, 85412, 85443, 85445, 85520, 85530, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85702, 85702, 85703, 85703, 85710, 85712, 85712, 85716, 85716, 85718, 85720, 85763, 85776, 85814, 86012, 86012, 86049, 86070, 86074, 86075, 86078, 86097, 86357, 86743, 86969, 86970, 87039, 87041, 87263, 87291, 87291, 87301, 87301, 87302, 87302, 87303, 87303, 87307, 87307, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87373, 87375, 87375, 87377, 87379, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87397, 87399, 87401, 87404, 87406, 87413, 87450, 87633, 87634, 87783, 87784, 87785, 87786, 87796, 87809, 87844, 87845, 87851, 87851, 87851, 87852, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87898, 87902, 87907, 87910, 87912, 87914, 87914, 87914, 87916, 87916, 87935, 88141, 88142, 88157, 88158, 88159, 88180, 88183, 88183, 88188, 88188, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88206, 88211, 88212, 88213, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88232, 88232, 88235, 88235, 88479, 88864, 89011, 89171, 89171, 89456, 89456, 89580, 89660, 90014, 90026, 90102, 90103, 90104, 90122, 90123, 90124, 90234, 90364, 90369, 90400, 90402, 90405, 90408, 90409, 90410, 90411, 90412, 90413, 90414, 90414, 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, 90438, 90451, 90451, 90460, 90468, 90469, 90685, 90686, 90687, 90688, 90691, 90692, 90693, 90694, 90704, 90717, 90740, 90750, 90750, 90750, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90815, 90822, 90829, 90836, 90843, 90850, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90972, 90977, 90982, 90987, 90997, 91001, 91001, 91002, 91008, 91009, 91010, 91011, 91012, 91013, 91016, 91016, 91018, 91018, 91019, 91019, 91021, 91021, 91028, 91029, 91030, 91031, 91032, 91033, 91034, 91057, 91061, 91068, 91320, 91321, 91325, 91327, 91327, 91332, 91375, 91386, 91387, 91394, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91424, 91429, 91434, 91439, 91444, 91449, 91476, 91481, 91506, 91507, 91507, 91511, 91512, 91540, 91582, 91585, 91587, 91587, 91587, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91609, 91611, 91622, 91623, 91624, 91625, 91626, 91627, 91643, 91644, 91645, 91646, 91647, 91649, 91653, 91654, 91657, 91666, 91675, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91718, 91718, 91719, 91720, 91749, 91753, 91754, 91840, 91843, 91844, 91891, 91896, 91969, 91977, 91978, 92091, 92094, 92095, 92133, 92134, 92136, 92137, 92180, 92181, 92182, 92183, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92318, 92330, 92370, 92381, 92497, 92513, 92514, 92515, 92516, 92698, 92703, 92713, 92725, 92729, 92760, 92776, 92778, 92780, 92827, 92828, 92866, 92867, 92922, 92943, 92961, 93045, 93046, 93055, 93119, 93193, 93226, 93241, 93245, 93276, 93286, 93287, 93288, 93348, 93532, 93536, 93591, 93607, 93726, 93727, 93728, 93729, 93730, 93748, 93791, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93809, 93810, 93811, 93822, 93823, 93824, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93885, 93897, 93898, 93899, 93905, 93969, 93969, 93984, 93985, 93990, 94269, 94270, 94272, 94273, 94274, 94321, 94321, 94322, 94322, 94324, 94335, 94336, 94343, 94343, 94357, 94358, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94396, 94397, 94398, 94418, 94418, 94427, 94427, 94427, 94429, 94429, 94429, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94451, 94458, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94566, 94569, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94599, 94599, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94668, 94669, 94670, 94671, 94672, 94709, 94710, 94711, 94712, 94713, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94747, 94749, 94751, 94751, 94761, 94765, 94766, 94775, 94826, 94849, 94851, 94860, 94862, 94862, 95052, 95053, 95054, 95055, 95056, 95057, 95063, 95087, 95088, 95088, 95089, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95138, 95138, 95142, 95143, 95144, 95150, 95153, 95156, 95158, 95163, 95183, 95194, 95194, 95199, 95204, 95205, 95206, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95248, 95250, 95252, 95255, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95279, 95284, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95336, 95337, 95338, 95339, 95340, 95343, 95347, 95348, 95349, 95367, 95406, 95411, 95412, 95415, 95416, 95417, 95418, 95419, 95420, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95506, 95524, 95525, 95526, 95527, 95528, 95529, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95587, 95591, 95595, 95596, 95597, 95602, 95606, 95626, 95628, 95633, 95637, 95641, 95642, 95643, 95644, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95662, 95663, 95664, 95665, 95666, 95667, 95680, 95681, 95682, 95683, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95800, 95805, 95821, 95898, 95899, 96036, 96097, 96098, 96112, 96113, 96116, 96117, 96120, 96126, 96128, 96129, 96132, 96133, 96138, 96139, 96140, 96141, 96143, 96144, 96145, 96146, 96147, 96167, 96193, 96195, 96198, 96215, 96229, 96230, 96231, 96298, 96299, 96300, 96303, 96304, 96305, 96307, 96309, 96328, 96374, 96375, 96376, 96388, 96402, 96404, 96437, 96444, 96450, 96495, 96496, 96497, 96498, 96507, 96508, 96509, 96550, 96551, 96552, 96567, 96588, 96593, 96639, 96641, 96729, 96740, 96741, 96743, 96744, 96750, 96768, 96823, 96833, 96837, 96852, 96853, 96854, 96855, 96862, 96868, 96869, 96872, 96882, 96894, 96898, 96945, 96957, 96959, 96960, 96964, 96970, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97035, 97089, 97106, 97162, 97174, 97177, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97219, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97240, 97241, 97242, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97272, 97273, 97274, 97276, 97279, 97280, 97281, 97283, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97307, 97308, 97309, 97313, 97314, 97318, 97319, 97320, 97321, 97322, 97333, 97335, 97338, 97341, 97344, 97370, 97370, 97378, 97383, 97383, 97387, 97391, 97392, 97394, 97647, 97651, 97675, 97676, 97686, 97687, 97688, 97689, 97712, 97713, 97714, 97715, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97721, 97721, 97725, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97792, 97794, 97794, 97796, 97800, 97801, 97802, 97803, 97804, 97806, 97807, 97812, 97813, 97814, 97822, 97823, 97824, 97828, 97840, 97843, 97844, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97982, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98060, 98060, 98060, 98064, 98064, 98064, 98070, 98073, 98076, 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, 98129, 98130, 98131, 98145, 98145, 98157, 98159, 98167, 98180, 98187, 98188, 98189, 98214, 98214, 98214, 98215, 98215, 98215, 98423, 98426, 98429, 98430, 98432, 98438, 98483, 98484, 98491, 98493, 98493, 98502, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98521, 98528, 98533, 98534, 98535, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98627, 98654, 98655, 98656, 98663, 98704, 98719, 98736, 98740, 98744, 98767, 98769, 98777, 98778, 98779, 98793, 98794, 98796, 98809, 98836, 98863, 98866, 98881, 98892, 98900, 98908, 98909, 98917, 98918, 98923, 98932, 98935, 98938, 98944, 98945, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99010, 99015, 99016, 99021, 99022, 99023, 99024, 99025, 99026, 99030, 99031, 99032, 99037, 99052, 99061, 99064, 99072, 99077, 99078, 99079, 99080, 99081, 99179, 99200, 99201, 99202, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99240, 99246, 99251, 99257, 99258, 99261, 99267, 99268, 99269, 99270, 99271, 99274, 99275, 99278, 99301, 99323, 99334, 99354, 99364, 99385, 99387, 99391, 99416, 99436, 99443, 99444, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99473, 99498, 99500, 99542, 99552, 99555, 99560, 99561, 99562, 99577, 99578, 99579, 99590, 99591, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99616, 99617, 99649, 99736, 99741, 99742, 99748) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc LIMIT 15 | 15 | 15 | 15 | |
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_speed` = 1 AND `Item`.`id` IN (6064, 6176, 6177, 12380, 34886, 34961, 34963, 34968, 34971, 34971, 34974, 34983, 35017, 35134, 35135, 35161, 35188, 35189, 35190, 35271, 35294, 35303, 35312, 35402, 35403, 35403, 35404, 35448, 35450, 35523, 35524, 35536, 35537, 35572, 35574, 35574, 35651, 35652, 35673, 35674, 35675, 35676, 35692, 35693, 35699, 35724, 35724, 35725, 35725, 35726, 35726, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 38504, 38504, 44694, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 44785, 44786, 44787, 44788, 45501, 54080, 54082, 57632, 57641, 57641, 57644, 57650, 57650, 57651, 57651, 57652, 57652, 57685, 57685, 57706, 57707, 57764, 57765, 58154, 58215, 58222, 64430, 64582, 64618, 64618, 64622, 64630, 64630, 64631, 64631, 64637, 64637, 64647, 64660, 64674, 65199, 65202, 65203, 65209, 65209, 65212, 65220, 65220, 65221, 65221, 65278, 65329, 65331, 65331, 65337, 65338, 65338, 65739, 65809, 70489, 71282, 72479, 72480, 73052, 73052, 73062, 73062, 73176, 73176, 73276, 73276, 73658, 73665, 73666, 73667, 73667, 73678, 73678, 73678, 73719, 73720, 73727, 73729, 73731, 73747, 73747, 73763, 73763, 73764, 73766, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73810, 73810, 73811, 73811, 73812, 73812, 73820, 73864, 73864, 73866, 73870, 73870, 73871, 74768, 74768, 74779, 74780, 74782, 74782, 76930, 76937, 77039, 77141, 77213, 77214, 77216, 77219, 77220, 77230, 77230, 77230, 77244, 77245, 77245, 77249, 77254, 77254, 77329, 77611, 77617, 77617, 77631, 77631, 77632, 77632, 77635, 77658, 77658, 77660, 77660, 77663, 77668, 77668, 77698, 77705, 77705, 77733, 77733, 77736, 77736, 78017, 78018, 78019, 78144, 79265, 79423, 80097, 80550, 80595, 80596, 80597, 80598, 80607, 80609, 80609, 80610, 80610, 80611, 80611, 80616, 80616, 80616, 80646, 80646, 80678, 80679, 80680, 80681, 80730, 80734, 80735, 80736, 80737, 80745, 80752, 80760, 80761, 80762, 80781, 80787, 81109, 81109, 81109, 81146, 81215, 81216, 81216, 81244, 81244, 81471, 81471, 81473, 81474, 81474, 81477, 81478, 81479, 81480, 81481, 81482, 81484, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81503, 81506, 81506, 81507, 81511, 81514, 81517, 81521, 81521, 81547, 81548, 81549, 81550, 81551, 81553, 81556, 81558, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81595, 81596, 81597, 81636, 82080, 82456, 82499, 82968, 83120, 83160, 83781, 83783, 83784, 83787, 83788, 83789, 83790, 83791, 83793, 83796, 83796, 83800, 83812, 83813, 83814, 83814, 83818, 83823, 83828, 83830, 83832, 83833, 83834, 83834, 83835, 83836, 83841, 83842, 83843, 83877, 83877, 83877, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83903, 83921, 83921, 83927, 84087, 84087, 84220, 84262, 84263, 84468, 84470, 84482, 84482, 84483, 84483, 84484, 84488, 84489, 84490, 84491, 84493, 84493, 84496, 84501, 84517, 84518, 84519, 84520, 84521, 84524, 84525, 84526, 84530, 84534, 84534, 84536, 84536, 84537, 84541, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84612, 84613, 84616, 84618, 84620, 84622, 84908, 84930, 84941, 84984, 84984, 84984, 84997, 85010, 85010, 85012, 85012, 85015, 85015, 85017, 85017, 85017, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85164, 85165, 85171, 85171, 85183, 85183, 85202, 85208, 85208, 85211, 85213, 85215, 85215, 85217, 85218, 85222, 85226, 85333, 85356, 85387, 85389, 85412, 85443, 85445, 85520, 85530, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 85702, 85702, 85703, 85703, 85710, 85712, 85712, 85716, 85716, 85718, 85720, 85763, 85776, 85814, 86012, 86012, 86049, 86070, 86074, 86075, 86078, 86097, 86357, 86743, 86969, 86970, 87039, 87041, 87263, 87291, 87291, 87301, 87301, 87302, 87302, 87303, 87303, 87307, 87307, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87373, 87375, 87375, 87377, 87379, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87397, 87399, 87401, 87404, 87406, 87413, 87450, 87633, 87634, 87783, 87784, 87785, 87786, 87796, 87809, 87844, 87845, 87851, 87851, 87851, 87852, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87898, 87902, 87907, 87910, 87912, 87914, 87914, 87914, 87916, 87916, 87935, 88141, 88142, 88157, 88158, 88159, 88180, 88183, 88183, 88188, 88188, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88206, 88211, 88212, 88213, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88232, 88232, 88235, 88235, 88479, 88864, 89011, 89171, 89171, 89456, 89456, 89580, 89660, 90014, 90026, 90102, 90103, 90104, 90122, 90123, 90124, 90234, 90364, 90369, 90400, 90402, 90405, 90408, 90409, 90410, 90411, 90412, 90413, 90414, 90414, 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, 90438, 90451, 90451, 90460, 90468, 90469, 90685, 90686, 90687, 90688, 90691, 90692, 90693, 90694, 90704, 90717, 90740, 90750, 90750, 90750, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90815, 90822, 90829, 90836, 90843, 90850, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90972, 90977, 90982, 90987, 90997, 91001, 91001, 91002, 91008, 91009, 91010, 91011, 91012, 91013, 91016, 91016, 91018, 91018, 91019, 91019, 91021, 91021, 91028, 91029, 91030, 91031, 91032, 91033, 91034, 91057, 91061, 91068, 91320, 91321, 91325, 91327, 91327, 91332, 91375, 91386, 91387, 91394, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91424, 91429, 91434, 91439, 91444, 91449, 91476, 91481, 91506, 91507, 91507, 91511, 91512, 91540, 91582, 91585, 91587, 91587, 91587, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91609, 91611, 91622, 91623, 91624, 91625, 91626, 91627, 91643, 91644, 91645, 91646, 91647, 91649, 91653, 91654, 91657, 91666, 91675, 91676, 91677, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91718, 91718, 91719, 91720, 91749, 91753, 91754, 91840, 91843, 91844, 91891, 91896, 91969, 91977, 91978, 92091, 92094, 92095, 92133, 92134, 92136, 92137, 92180, 92181, 92182, 92183, 92194, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92318, 92330, 92370, 92381, 92497, 92513, 92514, 92515, 92516, 92698, 92703, 92713, 92725, 92729, 92760, 92776, 92778, 92780, 92827, 92828, 92866, 92867, 92922, 92943, 92961, 93045, 93046, 93055, 93119, 93193, 93226, 93241, 93245, 93276, 93286, 93287, 93288, 93348, 93532, 93536, 93591, 93607, 93726, 93727, 93728, 93729, 93730, 93748, 93791, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93809, 93810, 93811, 93822, 93823, 93824, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93885, 93897, 93898, 93899, 93905, 93969, 93969, 93984, 93985, 93990, 94269, 94270, 94272, 94273, 94274, 94321, 94321, 94322, 94322, 94324, 94335, 94336, 94343, 94343, 94357, 94358, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94396, 94397, 94398, 94418, 94418, 94427, 94427, 94427, 94429, 94429, 94429, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94451, 94458, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94525, 94529, 94533, 94537, 94541, 94545, 94546, 94547, 94548, 94549, 94566, 94569, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94599, 94599, 94613, 94615, 94622, 94628, 94634, 94637, 94646, 94652, 94653, 94656, 94668, 94669, 94670, 94671, 94672, 94709, 94710, 94711, 94712, 94713, 94714, 94722, 94725, 94725, 94725, 94727, 94727, 94727, 94729, 94729, 94729, 94747, 94749, 94751, 94751, 94761, 94765, 94766, 94775, 94826, 94849, 94851, 94860, 94862, 94862, 95052, 95053, 95054, 95055, 95056, 95057, 95063, 95087, 95088, 95088, 95089, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95138, 95138, 95142, 95143, 95144, 95150, 95153, 95156, 95158, 95163, 95183, 95194, 95194, 95199, 95204, 95205, 95206, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 95248, 95250, 95252, 95255, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95279, 95284, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95312, 95312, 95316, 95321, 95325, 95330, 95335, 95336, 95337, 95338, 95339, 95340, 95343, 95347, 95348, 95349, 95367, 95406, 95411, 95412, 95415, 95416, 95417, 95418, 95419, 95420, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95435, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95506, 95524, 95525, 95526, 95527, 95528, 95529, 95545, 95550, 95552, 95554, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95587, 95591, 95595, 95596, 95597, 95602, 95606, 95626, 95628, 95633, 95637, 95641, 95642, 95643, 95644, 95645, 95649, 95653, 95655, 95656, 95657, 95661, 95662, 95663, 95664, 95665, 95666, 95667, 95680, 95681, 95682, 95683, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 95800, 95805, 95821, 95898, 95899, 96036, 96097, 96098, 96112, 96113, 96116, 96117, 96120, 96126, 96128, 96129, 96132, 96133, 96138, 96139, 96140, 96141, 96143, 96144, 96145, 96146, 96147, 96167, 96193, 96195, 96198, 96215, 96229, 96230, 96231, 96298, 96299, 96300, 96303, 96304, 96305, 96307, 96309, 96328, 96374, 96375, 96376, 96388, 96402, 96404, 96437, 96444, 96450, 96495, 96496, 96497, 96498, 96507, 96508, 96509, 96550, 96551, 96552, 96567, 96588, 96593, 96639, 96641, 96729, 96740, 96741, 96743, 96744, 96750, 96768, 96823, 96833, 96837, 96852, 96853, 96854, 96855, 96862, 96868, 96869, 96872, 96882, 96894, 96898, 96945, 96957, 96959, 96960, 96964, 96970, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97035, 97089, 97106, 97162, 97174, 97177, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97219, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97240, 97241, 97242, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97272, 97273, 97274, 97276, 97279, 97280, 97281, 97283, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97307, 97308, 97309, 97313, 97314, 97318, 97319, 97320, 97321, 97322, 97333, 97335, 97338, 97341, 97344, 97370, 97370, 97378, 97383, 97383, 97387, 97391, 97392, 97394, 97647, 97651, 97675, 97676, 97686, 97687, 97688, 97689, 97712, 97713, 97714, 97715, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97721, 97721, 97725, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97792, 97794, 97794, 97796, 97800, 97801, 97802, 97803, 97804, 97806, 97807, 97812, 97813, 97814, 97822, 97823, 97824, 97828, 97840, 97843, 97844, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97910, 97915, 97919, 97927, 97927, 97932, 97935, 97940, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97982, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98045, 98045, 98050, 98050, 98050, 98054, 98054, 98054, 98055, 98055, 98055, 98060, 98060, 98060, 98064, 98064, 98064, 98070, 98073, 98076, 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, 98129, 98130, 98131, 98145, 98145, 98157, 98159, 98167, 98180, 98187, 98188, 98189, 98214, 98214, 98214, 98215, 98215, 98215, 98423, 98426, 98429, 98430, 98432, 98438, 98483, 98484, 98491, 98493, 98493, 98502, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98521, 98528, 98533, 98534, 98535, 98536, 98540, 98545, 98550, 98555, 98560, 98564, 98568, 98572, 98576, 98580, 98584, 98588, 98592, 98592, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98627, 98654, 98655, 98656, 98663, 98704, 98719, 98736, 98740, 98744, 98767, 98769, 98777, 98778, 98779, 98793, 98794, 98796, 98809, 98836, 98863, 98866, 98881, 98892, 98900, 98908, 98909, 98917, 98918, 98923, 98932, 98935, 98938, 98944, 98945, 98968, 98970, 98973, 98978, 98979, 98985, 98989, 98992, 98999, 99010, 99015, 99016, 99021, 99022, 99023, 99024, 99025, 99026, 99030, 99031, 99032, 99037, 99052, 99061, 99064, 99072, 99077, 99078, 99079, 99080, 99081, 99179, 99200, 99201, 99202, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99240, 99246, 99251, 99257, 99258, 99261, 99267, 99268, 99269, 99270, 99271, 99274, 99275, 99278, 99301, 99323, 99334, 99354, 99364, 99385, 99387, 99391, 99416, 99436, 99443, 99444, 99463, 99464, 99465, 99466, 99467, 99468, 99469, 99470, 99471, 99473, 99498, 99500, 99542, 99552, 99555, 99560, 99561, 99562, 99577, 99578, 99579, 99590, 99591, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99616, 99617, 99649, 99736, 99741, 99742, 99748) AND `item_rank` <> 3 | 1 | 1 | 10 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98533) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0155-008'))))) OR (((`item_id2` = 98533) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0155-008'))))) OR (((`item_id3` = 98533) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0155-008')))))) 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` = 98533 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98534) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0155-044'))))) OR (((`item_id2` = 98534) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0155-044'))))) OR (((`item_id3` = 98534) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0155-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` = 98534 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95325) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0130-044'))))) OR (((`item_id2` = 95325) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0130-044'))))) OR (((`item_id3` = 95325) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0130-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` = 95325 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95642) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-002'))))) OR (((`item_id2` = 95642) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-002'))))) OR (((`item_id3` = 95642) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-002')))))) 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` = 95642 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95643) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-006'))))) OR (((`item_id2` = 95643) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-006'))))) OR (((`item_id3` = 95643) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95643 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95644) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-009'))))) OR (((`item_id2` = 95644) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-009'))))) OR (((`item_id3` = 95644) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-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` = 95644 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-044'))))) OR (((`item_id2` = 95645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-044'))))) OR (((`item_id3` = 95645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-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` = 95645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98502) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-044'))))) OR (((`item_id2` = 98502) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-044'))))) OR (((`item_id3` = 98502) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-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` = 98502 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95653) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0143-044'))))) OR (((`item_id2` = 95653) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0143-044'))))) OR (((`item_id3` = 95653) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0143-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` = 95653 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95302) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-002'))))) OR (((`item_id2` = 95302) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-002'))))) OR (((`item_id3` = 95302) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-002')))))) 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` = 95302 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95303) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-009'))))) OR (((`item_id2` = 95303) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-009'))))) OR (((`item_id3` = 95303) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-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` = 95303 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95304) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-010'))))) OR (((`item_id2` = 95304) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-010'))))) OR (((`item_id3` = 95304) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-010')))))) 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` = 95304 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95305) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-025'))))) OR (((`item_id2` = 95305) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-025'))))) OR (((`item_id3` = 95305) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-025')))))) 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` = 95305 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95306) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-034'))))) OR (((`item_id2` = 95306) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-034'))))) OR (((`item_id3` = 95306) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-034')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95306 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95307) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0121-038'))))) OR (((`item_id2` = 95307) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0121-038'))))) OR (((`item_id3` = 95307) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0121-038')))))) 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` = 95307 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 | |