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 '%[DIYツール]%') OR (`Item`.`item_name` Like '%[DIYツール]%') OR (`Item`.`item_figure` Like '%[DIYツール]%') OR (`Item`.`item_color` Like '%[DIYツール]%') OR (`Item`.`item_materials` Like '%[DIYツール]%') OR (`Item`.`item_note` Like '%[DIYツール]%') 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 '%51%') OR (`Item`.`item_name` Like '%51%') OR (`Item`.`item_figure` Like '%51%') OR (`Item`.`item_color` Like '%51%') OR (`Item`.`item_materials` Like '%51%') OR (`Item`.`item_note` Like '%51%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1010 | 1010 | 1 | |
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 (6274, 6274, 35016, 35017, 35243, 35244, 35245, 35326, 35328, 35665, 35760, 35760, 35764, 35764, 36244, 57708, 57709, 65033, 65033, 65251, 65252, 65373, 65720, 68215, 68215, 68510, 68606, 68607, 68732, 70203, 71282, 71525, 71526, 71532, 71533, 71777, 71778, 71780, 71886, 71888, 73691, 73691, 73781, 73781, 74221, 74225, 74226, 74227, 74263, 74264, 74268, 74269, 75898, 76107, 76118, 76813, 78795, 78795, 79302, 80470, 80471, 80472, 81215, 81628, 81629, 81630, 82453, 82454, 82455, 82456, 82630, 82911, 83385, 83422, 83422, 83938, 83938, 84149, 84173, 84421, 84421, 84476, 84477, 84478, 84479, 84480, 84480, 84481, 84481, 84484, 84485, 84486, 84487, 84537, 84538, 84539, 84539, 84540, 84593, 84593, 84594, 84594, 85032, 85505, 86012, 86012, 86023, 86049, 86372, 86421, 86436, 87013, 87039, 87041, 87784, 87913, 87913, 87913, 87914, 87914, 87914, 88228, 88228, 88244, 88453, 88454, 88455, 88479, 88540, 88594, 88595, 88685, 88972, 89011, 89405, 89552, 89659, 89660, 89661, 89662, 89745, 89746, 89766, 89766, 90102, 90103, 90104, 90122, 90123, 90124, 90325, 90361, 90362, 90363, 90452, 90452, 91401, 91497, 91567, 91759, 91783, 91785, 91786, 91790, 91791, 91800, 91801, 91802, 91803, 91804, 91805, 91806, 91807, 91808, 91827, 91833, 91834, 91835, 91836, 91839, 91840, 91841, 91843, 91844, 91859, 91883, 91884, 91885, 91886, 91891, 91916, 91917, 91968, 91969, 91977, 91978, 92022, 92023, 92089, 92091, 92092, 92093, 92094, 92095, 92101, 92108, 92110, 92111, 92113, 92114, 92133, 92134, 92136, 92137, 92180, 92181, 92182, 92183, 92185, 92186, 92381, 92382, 92389, 92390, 92391, 92395, 92396, 92397, 92441, 92442, 92443, 92444, 92445, 92446, 92447, 92448, 92449, 92450, 92451, 92471, 92511, 92630, 92631, 92669, 92670, 92695, 92696, 92697, 92698, 92699, 92700, 92701, 92702, 92703, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 92747, 92749, 92757, 92760, 92766, 92769, 92771, 92772, 92775, 92781, 92802, 92803, 92826, 92827, 92828, 92829, 93064, 93151, 93153, 93154, 93161, 93272, 93273, 93492, 93506, 93511, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93568, 93631, 93636, 93768, 93769, 93770, 93771, 93772, 93784, 93785, 93786, 93787, 93788, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93812, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93881, 94326, 94478, 94479, 94480, 94481, 94482, 94515, 94516, 94517, 94575, 94576, 94577, 94578, 95123, 95341, 95364, 95364, 95365, 95365, 95371, 95375, 95377, 95388, 95389, 95390, 95582, 95605, 95609, 95610, 95611, 95612, 95613, 95614, 95615, 95618, 95619, 95620, 95665, 95788, 95791, 95792, 95793, 95800, 95801, 95802, 95806, 95829, 95863, 95864, 95865, 95875, 95904, 95924, 95925, 95926, 95951, 95952, 95953, 95998, 95999, 96000, 96001, 96064, 96065, 96066, 96067, 96091, 96097, 96098, 96106, 96107, 96112, 96113, 96114, 96115, 96116, 96117, 96118, 96120, 96121, 96122, 96123, 96124, 96148, 96149, 96150, 96151, 96152, 96160, 96161, 96162, 96163, 96164, 96165, 96166, 96167, 96178, 96179, 96180, 96182, 96183, 96184, 96185, 96186, 96187, 96188, 96189, 96192, 96193, 96354, 96355, 96356, 96373, 96379, 96386, 96387, 96388, 96389, 96390, 96392, 96393, 96401, 96419, 96420, 96421, 96423, 96425, 96430, 96431, 96432, 96434, 96437, 96440, 96444, 96445, 96446, 96448, 96456, 96470, 96475, 96476, 96477, 96478, 96485, 96486, 96487, 96491, 96492, 96493, 96494, 96504, 96515, 96516, 96529, 96531, 96532, 96533, 96534, 96538, 96539, 96540, 96542, 96543, 96589, 96590, 96593, 96596, 96597, 96666, 96667, 96668, 96669, 96671, 96704, 96713, 96714, 96715, 96716, 96718, 96719, 96720, 96726, 96729, 96731, 96760, 96781, 96782, 96783, 96809, 96810, 96846, 96851, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96863, 96867, 96868, 96869, 96915, 96916, 96917, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97197, 97198, 97199, 97200, 97201, 97202, 97203, 97204, 97205, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97240, 97241, 97242, 97243, 97244, 97245, 97246, 97247, 97248, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97262, 97263, 97264, 97269, 97270, 97271, 97281, 97282, 97283, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97367, 97367, 97380, 97389, 97663, 97707, 97799, 97822, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 98207, 98444, 98454, 98455, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98631, 98632, 98635, 98636, 98638, 98647, 98648, 98649, 98652, 98653, 98654, 98655, 98656, 98657, 98658, 98663, 98664, 98665, 98682, 98683, 98684, 98685, 98686, 98687, 98698, 98699, 98700, 98701, 98708, 98721, 98722, 98723, 98724, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98738, 98739, 98740, 98741, 98742, 98743, 98744, 98745, 98746, 98747, 98748, 98749, 98763, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98774, 98775, 98776, 98777, 98778, 98779, 98780, 98798, 98799, 98800, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98833, 98834, 98835, 98836, 98867, 98868, 98869, 98870, 98871, 98872, 98873, 98874, 98875, 98953, 98954, 98963, 98971, 98972, 98973, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99027, 99028, 99029, 99030, 99031, 99032, 99033, 99034, 99035, 99036, 99037, 99038, 99039, 99040, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99082, 99083, 99084, 99085, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99106, 99107, 99108, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99118, 99119, 99120, 99121, 99122, 99200, 99201, 99202, 99203, 99204, 99205, 99206, 99207, 99208, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99223, 99224, 99225, 99226, 99227, 99228, 99229, 99230, 99231, 99232, 99233, 99234, 99235, 99236, 99237, 99238, 99245, 99287, 99288, 99289, 99290, 99291, 99292, 99293, 99294, 99295, 99296, 99312, 99319, 99336, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99347, 99348, 99349, 99350, 99351, 99352, 99353, 99358, 99370, 99371, 99414, 99415, 99443, 99444, 99445, 99446, 99447, 99448, 99449, 99459, 99460, 99461, 99462, 99476, 99493, 99494, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99588, 99589, 99590, 99591, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99602, 99603, 99608, 99609, 99610, 99611, 99612, 99613, 99614, 99615, 99616, 99617, 99618, 99619, 99620, 99621, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99673, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99759, 99760, 99761, 99762, 99763, 99764, 99765, 99766, 99767, 99768, 99769, 99770, 99771, 99772, 99773, 99774, 99775) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 3 | 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 (6274, 6274, 35016, 35017, 35243, 35244, 35245, 35326, 35328, 35665, 35760, 35760, 35764, 35764, 36244, 57708, 57709, 65033, 65033, 65251, 65252, 65373, 65720, 68215, 68215, 68510, 68606, 68607, 68732, 70203, 71282, 71525, 71526, 71532, 71533, 71777, 71778, 71780, 71886, 71888, 73691, 73691, 73781, 73781, 74221, 74225, 74226, 74227, 74263, 74264, 74268, 74269, 75898, 76107, 76118, 76813, 78795, 78795, 79302, 80470, 80471, 80472, 81215, 81628, 81629, 81630, 82453, 82454, 82455, 82456, 82630, 82911, 83385, 83422, 83422, 83938, 83938, 84149, 84173, 84421, 84421, 84476, 84477, 84478, 84479, 84480, 84480, 84481, 84481, 84484, 84485, 84486, 84487, 84537, 84538, 84539, 84539, 84540, 84593, 84593, 84594, 84594, 85032, 85505, 86012, 86012, 86023, 86049, 86372, 86421, 86436, 87013, 87039, 87041, 87784, 87913, 87913, 87913, 87914, 87914, 87914, 88228, 88228, 88244, 88453, 88454, 88455, 88479, 88540, 88594, 88595, 88685, 88972, 89011, 89405, 89552, 89659, 89660, 89661, 89662, 89745, 89746, 89766, 89766, 90102, 90103, 90104, 90122, 90123, 90124, 90325, 90361, 90362, 90363, 90452, 90452, 91401, 91497, 91567, 91759, 91783, 91785, 91786, 91790, 91791, 91800, 91801, 91802, 91803, 91804, 91805, 91806, 91807, 91808, 91827, 91833, 91834, 91835, 91836, 91839, 91840, 91841, 91843, 91844, 91859, 91883, 91884, 91885, 91886, 91891, 91916, 91917, 91968, 91969, 91977, 91978, 92022, 92023, 92089, 92091, 92092, 92093, 92094, 92095, 92101, 92108, 92110, 92111, 92113, 92114, 92133, 92134, 92136, 92137, 92180, 92181, 92182, 92183, 92185, 92186, 92381, 92382, 92389, 92390, 92391, 92395, 92396, 92397, 92441, 92442, 92443, 92444, 92445, 92446, 92447, 92448, 92449, 92450, 92451, 92471, 92511, 92630, 92631, 92669, 92670, 92695, 92696, 92697, 92698, 92699, 92700, 92701, 92702, 92703, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 92747, 92749, 92757, 92760, 92766, 92769, 92771, 92772, 92775, 92781, 92802, 92803, 92826, 92827, 92828, 92829, 93064, 93151, 93153, 93154, 93161, 93272, 93273, 93492, 93506, 93511, 93530, 93531, 93532, 93533, 93534, 93536, 93539, 93540, 93541, 93542, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93568, 93631, 93636, 93768, 93769, 93770, 93771, 93772, 93784, 93785, 93786, 93787, 93788, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93812, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93881, 94326, 94478, 94479, 94480, 94481, 94482, 94515, 94516, 94517, 94575, 94576, 94577, 94578, 95123, 95341, 95364, 95364, 95365, 95365, 95371, 95375, 95377, 95388, 95389, 95390, 95582, 95605, 95609, 95610, 95611, 95612, 95613, 95614, 95615, 95618, 95619, 95620, 95665, 95788, 95791, 95792, 95793, 95800, 95801, 95802, 95806, 95829, 95863, 95864, 95865, 95875, 95904, 95924, 95925, 95926, 95951, 95952, 95953, 95998, 95999, 96000, 96001, 96064, 96065, 96066, 96067, 96091, 96097, 96098, 96106, 96107, 96112, 96113, 96114, 96115, 96116, 96117, 96118, 96120, 96121, 96122, 96123, 96124, 96148, 96149, 96150, 96151, 96152, 96160, 96161, 96162, 96163, 96164, 96165, 96166, 96167, 96178, 96179, 96180, 96182, 96183, 96184, 96185, 96186, 96187, 96188, 96189, 96192, 96193, 96354, 96355, 96356, 96373, 96379, 96386, 96387, 96388, 96389, 96390, 96392, 96393, 96401, 96419, 96420, 96421, 96423, 96425, 96430, 96431, 96432, 96434, 96437, 96440, 96444, 96445, 96446, 96448, 96456, 96470, 96475, 96476, 96477, 96478, 96485, 96486, 96487, 96491, 96492, 96493, 96494, 96504, 96515, 96516, 96529, 96531, 96532, 96533, 96534, 96538, 96539, 96540, 96542, 96543, 96589, 96590, 96593, 96596, 96597, 96666, 96667, 96668, 96669, 96671, 96704, 96713, 96714, 96715, 96716, 96718, 96719, 96720, 96726, 96729, 96731, 96760, 96781, 96782, 96783, 96809, 96810, 96846, 96851, 96852, 96853, 96854, 96855, 96856, 96858, 96859, 96860, 96861, 96862, 96863, 96867, 96868, 96869, 96915, 96916, 96917, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97197, 97198, 97199, 97200, 97201, 97202, 97203, 97204, 97205, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97240, 97241, 97242, 97243, 97244, 97245, 97246, 97247, 97248, 97249, 97250, 97253, 97254, 97255, 97256, 97257, 97258, 97262, 97263, 97264, 97269, 97270, 97271, 97281, 97282, 97283, 97284, 97285, 97286, 97287, 97288, 97289, 97290, 97291, 97367, 97367, 97380, 97389, 97663, 97707, 97799, 97822, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 98207, 98444, 98454, 98455, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98631, 98632, 98635, 98636, 98638, 98647, 98648, 98649, 98652, 98653, 98654, 98655, 98656, 98657, 98658, 98663, 98664, 98665, 98682, 98683, 98684, 98685, 98686, 98687, 98698, 98699, 98700, 98701, 98708, 98721, 98722, 98723, 98724, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98738, 98739, 98740, 98741, 98742, 98743, 98744, 98745, 98746, 98747, 98748, 98749, 98763, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98774, 98775, 98776, 98777, 98778, 98779, 98780, 98798, 98799, 98800, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98833, 98834, 98835, 98836, 98867, 98868, 98869, 98870, 98871, 98872, 98873, 98874, 98875, 98953, 98954, 98963, 98971, 98972, 98973, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99027, 99028, 99029, 99030, 99031, 99032, 99033, 99034, 99035, 99036, 99037, 99038, 99039, 99040, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99082, 99083, 99084, 99085, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99106, 99107, 99108, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99118, 99119, 99120, 99121, 99122, 99200, 99201, 99202, 99203, 99204, 99205, 99206, 99207, 99208, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99223, 99224, 99225, 99226, 99227, 99228, 99229, 99230, 99231, 99232, 99233, 99234, 99235, 99236, 99237, 99238, 99245, 99287, 99288, 99289, 99290, 99291, 99292, 99293, 99294, 99295, 99296, 99312, 99319, 99336, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99347, 99348, 99349, 99350, 99351, 99352, 99353, 99358, 99370, 99371, 99414, 99415, 99443, 99444, 99445, 99446, 99447, 99448, 99449, 99459, 99460, 99461, 99462, 99476, 99493, 99494, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99588, 99589, 99590, 99591, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99602, 99603, 99608, 99609, 99610, 99611, 99612, 99613, 99614, 99615, 99616, 99617, 99618, 99619, 99620, 99621, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99673, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99759, 99760, 99761, 99762, 99763, 99764, 99765, 99766, 99767, 99768, 99769, 99770, 99771, 99772, 99773, 99774, 99775) AND `item_rank` <> 3 | 1 | 1 | 3 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 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` = 96150) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25153G9C'))))) OR (((`item_id2` = 96150) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25153G9C'))))) OR (((`item_id3` = 96150) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25153G9C')))))) 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` = 96150 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-044'))))) OR (((`item_id2` = 98516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-044'))))) OR (((`item_id3` = 98516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98515) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-009'))))) OR (((`item_id2` = 98515) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-009'))))) OR (((`item_id3` = 98515) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98515 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98514) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-006'))))) OR (((`item_id2` = 98514) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-006'))))) OR (((`item_id3` = 98514) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98514 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98513) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-005'))))) OR (((`item_id2` = 98513) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-005'))))) OR (((`item_id3` = 98513) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-005')))))) 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` = 98513 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98512) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-002'))))) OR (((`item_id2` = 98512) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-002'))))) OR (((`item_id3` = 98512) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98512 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95377) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325110'))))) OR (((`item_id2` = 95377) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325110'))))) OR (((`item_id3` = 95377) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325110')))))) 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` = 95377 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96066) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25189G9A'))))) OR (((`item_id2` = 96066) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25189G9A'))))) OR (((`item_id3` = 96066) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25189G9A')))))) 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` = 96066 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95605) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846251'))))) OR (((`item_id2` = 95605) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846251'))))) OR (((`item_id3` = 95605) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846251')))))) 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` = 95605 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98444) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375131'))))) OR (((`item_id2` = 98444) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375131'))))) OR (((`item_id3` = 98444) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375131')))))) 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` = 98444 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98455) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375251'))))) OR (((`item_id2` = 98455) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375251'))))) OR (((`item_id3` = 98455) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375251')))))) 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` = 98455 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98454) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375191'))))) OR (((`item_id2` = 98454) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375191'))))) OR (((`item_id3` = 98454) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375191')))))) 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` = 98454 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92091) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25108G3'))))) OR (((`item_id2` = 92091) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25108G3'))))) OR (((`item_id3` = 92091) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25108G3')))))) 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` = 92091 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96539) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25134G6B'))))) OR (((`item_id2` = 96539) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25134G6B'))))) OR (((`item_id3` = 96539) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25134G6B')))))) 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` = 96539 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 | |