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 | 985 | 985 | 594 | maybe slow |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (6775, 6776, 71886, 71888, 71928, 72204, 72448, 72448, 72479, 72480, 72799, 72827, 72832, 73052, 73052, 73062, 73062, 73276, 73276, 74439, 74440, 74944, 74948, 76813, 76929, 76930, 76933, 76937, 76942, 76977, 76977, 77683, 77684, 77685, 77686, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78795, 78795, 79302, 80607, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81150, 81150, 81545, 81545, 81546, 81546, 81872, 81905, 83120, 83726, 83853, 83854, 83855, 83855, 83859, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84097, 84100, 84106, 84257, 84262, 84263, 84517, 84518, 84906, 85039, 85039, 85040, 85040, 85041, 85041, 85387, 85414, 85776, 85777, 85809, 85811, 86010, 86055, 86057, 86059, 86060, 86357, 86636, 87039, 87271, 87272, 87274, 87275, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87653, 87654, 87662, 87664, 87665, 88144, 88173, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88228, 88228, 88229, 88229, 89456, 89456, 89467, 89467, 89837, 89894, 89931, 89932, 89933, 90102, 90103, 90104, 90122, 90123, 90124, 90190, 90353, 90354, 90356, 90357, 90390, 90391, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 91029, 91030, 91031, 91032, 91033, 91034, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91327, 91327, 91328, 91328, 91332, 91347, 91367, 91371, 91373, 91375, 91507, 91507, 91512, 91557, 91560, 91567, 91568, 91582, 91585, 91830, 92061, 92064, 92068, 92070, 92071, 92072, 92074, 92075, 92076, 92085, 92086, 92133, 92134, 92441, 92442, 92831, 93113, 93119, 93123, 93124, 93125, 93129, 93130, 93136, 93161, 93162, 93193, 93195, 93300, 93301, 93302, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93768, 93769, 93770, 93771, 93772, 93786, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93905, 93909, 93910, 93972, 93984, 94021, 94033, 94036, 94037, 94350, 94363, 94563, 94564, 94746, 94767, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 94812, 95087, 95089, 95099, 95100, 95109, 95111, 95113, 95114, 95120, 95121, 95155, 95159, 95161, 95161, 95162, 95162, 95163, 95180, 95183, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95249, 95250, 95364, 95364, 95365, 95365, 95376, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 95411, 95412, 95413, 95414, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95875, 95876, 95878, 95880, 95884, 95885, 95886, 95887, 95888, 96039, 96041, 96123, 96124, 96128, 96134, 96135, 96136, 96137, 96245, 96246, 96247, 96248, 96251, 96253, 96254, 96257, 96266, 96271, 96274, 96275, 96277, 96280, 96285, 96286, 96287, 96288, 96289, 96293, 96294, 96361, 96362, 96374, 96375, 96376, 96445, 96515, 96516, 96685, 96686, 96687, 96690, 96691, 96692, 96696, 96704, 96709, 96710, 96744, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97047, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97059, 97060, 97063, 97064, 97068, 97069, 97070, 97071, 97079, 97080, 97083, 97084, 97089, 97099, 97100, 97101, 97102, 97103, 97105, 97106, 97107, 97108, 97113, 97114, 97115, 97116, 97117, 97118, 97121, 97122, 97123, 97124, 97125, 97128, 97129, 97130, 97131, 97134, 97135, 97136, 97138, 97139, 97140, 97141, 97142, 97143, 97144, 97146, 97147, 97148, 97149, 97150, 97151, 97155, 97156, 97158, 97159, 97160, 97161, 97162, 97163, 97165, 97170, 97173, 97174, 97175, 97176, 97177, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97197, 97198, 97199, 97200, 97201, 97203, 97204, 97205, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97243, 97244, 97245, 97246, 97249, 97253, 97256, 97257, 97258, 97272, 97273, 97274, 97279, 97282, 97294, 97295, 97301, 97334, 97335, 97336, 97337, 97338, 97340, 97341, 97342, 97343, 97392, 97394, 97426, 97428, 97429, 97612, 97784, 97785, 97786, 97787, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97835, 97836, 97837, 97838, 97839, 97876, 97877, 97878, 97879, 97880, 97881, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 98003, 98004, 98005, 98006, 98007, 98008, 98139, 98157, 98180, 98190, 98200, 98201, 98202, 98203, 98204, 98205, 98206, 98207, 98208, 98209, 98210, 98211, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98464, 98465, 98466, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98480, 98481, 98482, 98483, 98484, 98485, 98486, 98487, 98488, 98489, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98593, 98594, 98595, 98596, 98597, 98598, 98627, 98630, 98671, 98672, 98673, 98674, 98678, 98688, 98689, 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, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99139, 99140, 99141, 99142, 99143, 99144, 99145, 99146, 99147, 99148, 99149, 99150, 99151, 99152, 99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 99162, 99163, 99164, 99165, 99166, 99167, 99168, 99169, 99170, 99171, 99172, 99173, 99174, 99175, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99189, 99190, 99191, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99200, 99201, 99202, 99203, 99204, 99205, 99206, 99207, 99208, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99224, 99225, 99226, 99227, 99229, 99230, 99231, 99232, 99237, 99238, 99247, 99588, 99589, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99604, 99605, 99606, 99607, 99619, 99625, 99626, 99627, 99628, 99697, 99698, 99699, 99700, 99701, 99702, 99703, 99704, 99705, 99706, 99707, 99708, 99709, 99710, 99711, 99712, 99713, 99714, 99715, 99716, 99717, 99718, 99719, 99720, 99721, 99722) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc LIMIT 15 | 15 | 15 | 7 | 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 (6775, 6776, 71886, 71888, 71928, 72204, 72448, 72448, 72479, 72480, 72799, 72827, 72832, 73052, 73052, 73062, 73062, 73276, 73276, 74439, 74440, 74944, 74948, 76813, 76929, 76930, 76933, 76937, 76942, 76977, 76977, 77683, 77684, 77685, 77686, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78795, 78795, 79302, 80607, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81150, 81150, 81545, 81545, 81546, 81546, 81872, 81905, 83120, 83726, 83853, 83854, 83855, 83855, 83859, 84059, 84061, 84064, 84073, 84079, 84080, 84080, 84081, 84084, 84085, 84086, 84086, 84087, 84087, 84091, 84093, 84097, 84100, 84106, 84257, 84262, 84263, 84517, 84518, 84906, 85039, 85039, 85040, 85040, 85041, 85041, 85387, 85414, 85776, 85777, 85809, 85811, 86010, 86055, 86057, 86059, 86060, 86357, 86636, 87039, 87271, 87272, 87274, 87275, 87279, 87284, 87284, 87286, 87287, 87287, 87291, 87291, 87295, 87295, 87653, 87654, 87662, 87664, 87665, 88144, 88173, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88228, 88228, 88229, 88229, 89456, 89456, 89467, 89467, 89837, 89894, 89931, 89932, 89933, 90102, 90103, 90104, 90122, 90123, 90124, 90190, 90353, 90354, 90356, 90357, 90390, 90391, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 91029, 91030, 91031, 91032, 91033, 91034, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91327, 91327, 91328, 91328, 91332, 91347, 91367, 91371, 91373, 91375, 91507, 91507, 91512, 91557, 91560, 91567, 91568, 91582, 91585, 91830, 92061, 92064, 92068, 92070, 92071, 92072, 92074, 92075, 92076, 92085, 92086, 92133, 92134, 92441, 92442, 92831, 93113, 93119, 93123, 93124, 93125, 93129, 93130, 93136, 93161, 93162, 93193, 93195, 93300, 93301, 93302, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93768, 93769, 93770, 93771, 93772, 93786, 93789, 93790, 93791, 93792, 93793, 93794, 93799, 93800, 93801, 93802, 93803, 93804, 93805, 93806, 93807, 93808, 93809, 93810, 93811, 93820, 93850, 93851, 93852, 93853, 93854, 93855, 93856, 93883, 93905, 93909, 93910, 93972, 93984, 94021, 94033, 94036, 94037, 94350, 94363, 94563, 94564, 94746, 94767, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 94812, 95087, 95089, 95099, 95100, 95109, 95111, 95113, 95114, 95120, 95121, 95155, 95159, 95161, 95161, 95162, 95162, 95163, 95180, 95183, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95249, 95250, 95364, 95364, 95365, 95365, 95376, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 95411, 95412, 95413, 95414, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95875, 95876, 95878, 95880, 95884, 95885, 95886, 95887, 95888, 96039, 96041, 96123, 96124, 96128, 96134, 96135, 96136, 96137, 96245, 96246, 96247, 96248, 96251, 96253, 96254, 96257, 96266, 96271, 96274, 96275, 96277, 96280, 96285, 96286, 96287, 96288, 96289, 96293, 96294, 96361, 96362, 96374, 96375, 96376, 96445, 96515, 96516, 96685, 96686, 96687, 96690, 96691, 96692, 96696, 96704, 96709, 96710, 96744, 96978, 96979, 96980, 96981, 96999, 97000, 97001, 97002, 97003, 97004, 97020, 97021, 97022, 97023, 97024, 97026, 97028, 97029, 97030, 97031, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97041, 97042, 97043, 97044, 97045, 97047, 97048, 97049, 97050, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97059, 97060, 97063, 97064, 97068, 97069, 97070, 97071, 97079, 97080, 97083, 97084, 97089, 97099, 97100, 97101, 97102, 97103, 97105, 97106, 97107, 97108, 97113, 97114, 97115, 97116, 97117, 97118, 97121, 97122, 97123, 97124, 97125, 97128, 97129, 97130, 97131, 97134, 97135, 97136, 97138, 97139, 97140, 97141, 97142, 97143, 97144, 97146, 97147, 97148, 97149, 97150, 97151, 97155, 97156, 97158, 97159, 97160, 97161, 97162, 97163, 97165, 97170, 97173, 97174, 97175, 97176, 97177, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97197, 97198, 97199, 97200, 97201, 97203, 97204, 97205, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97220, 97221, 97222, 97223, 97224, 97225, 97234, 97235, 97236, 97237, 97238, 97239, 97243, 97244, 97245, 97246, 97249, 97253, 97256, 97257, 97258, 97272, 97273, 97274, 97279, 97282, 97294, 97295, 97301, 97334, 97335, 97336, 97337, 97338, 97340, 97341, 97342, 97343, 97392, 97394, 97426, 97428, 97429, 97612, 97784, 97785, 97786, 97787, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97835, 97836, 97837, 97838, 97839, 97876, 97877, 97878, 97879, 97880, 97881, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 98003, 98004, 98005, 98006, 98007, 98008, 98139, 98157, 98180, 98190, 98200, 98201, 98202, 98203, 98204, 98205, 98206, 98207, 98208, 98209, 98210, 98211, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98464, 98465, 98466, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98480, 98481, 98482, 98483, 98484, 98485, 98486, 98487, 98488, 98489, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98593, 98594, 98595, 98596, 98597, 98598, 98627, 98630, 98671, 98672, 98673, 98674, 98678, 98688, 98689, 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, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99139, 99140, 99141, 99142, 99143, 99144, 99145, 99146, 99147, 99148, 99149, 99150, 99151, 99152, 99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 99162, 99163, 99164, 99165, 99166, 99167, 99168, 99169, 99170, 99171, 99172, 99173, 99174, 99175, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99189, 99190, 99191, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99200, 99201, 99202, 99203, 99204, 99205, 99206, 99207, 99208, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99221, 99222, 99224, 99225, 99226, 99227, 99229, 99230, 99231, 99232, 99237, 99238, 99247, 99588, 99589, 99592, 99593, 99594, 99595, 99596, 99597, 99598, 99599, 99600, 99601, 99604, 99605, 99606, 99607, 99619, 99625, 99626, 99627, 99628, 99697, 99698, 99699, 99700, 99701, 99702, 99703, 99704, 99705, 99706, 99707, 99708, 99709, 99710, 99711, 99712, 99713, 99714, 99715, 99716, 99717, 99718, 99719, 99720, 99721, 99722) 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` = 97058) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25334G1'))))) OR (((`item_id2` = 97058) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25334G1'))))) OR (((`item_id3` = 97058) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25334G1')))))) 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` = 97058 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97186) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25235G8A'))))) OR (((`item_id2` = 97186) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25235G8A'))))) OR (((`item_id3` = 97186) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25235G8A')))))) 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` = 97186 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97187) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25235G8B'))))) OR (((`item_id2` = 97187) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25235G8B'))))) OR (((`item_id3` = 97187) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25235G8B')))))) 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` = 97187 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97188) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25235G8C'))))) OR (((`item_id2` = 97188) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25235G8C'))))) OR (((`item_id3` = 97188) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25235G8C')))))) 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` = 97188 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97189) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25235G8D'))))) OR (((`item_id2` = 97189) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25235G8D'))))) OR (((`item_id3` = 97189) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25235G8D')))))) 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` = 97189 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98488) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476892'))))) OR (((`item_id2` = 98488) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476892'))))) OR (((`item_id3` = 98488) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476892')))))) 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` = 98488 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78106) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LS0124AT'))))) OR (((`item_id2` = 78106) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LS0124AT'))))) OR (((`item_id3` = 78106) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LS0124AT')))))) 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` = 78106 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78107) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LS0124AN'))))) OR (((`item_id2` = 78107) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LS0124AN'))))) OR (((`item_id3` = 78107) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LS0124AN')))))) 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` = 78107 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78108) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LS0124AF'))))) OR (((`item_id2` = 78108) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LS0124AF'))))) OR (((`item_id3` = 78108) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LS0124AF')))))) 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` = 78108 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97057) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25325G9'))))) OR (((`item_id2` = 97057) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25325G9'))))) OR (((`item_id3` = 97057) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25325G9')))))) 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` = 97057 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92086) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25325G6'))))) OR (((`item_id2` = 92086) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25325G6'))))) OR (((`item_id3` = 92086) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25325G6')))))) 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` = 92086 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95684) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0003-006'))))) OR (((`item_id2` = 95684) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0003-006'))))) OR (((`item_id3` = 95684) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0003-006')))))) 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` = 95684 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95685) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0003-009'))))) OR (((`item_id2` = 95685) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0003-009'))))) OR (((`item_id3` = 95685) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0003-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` = 95685 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95686) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0003-013'))))) OR (((`item_id2` = 95686) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0003-013'))))) OR (((`item_id3` = 95686) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0003-013')))))) 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` = 95686 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95687) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0003-028'))))) OR (((`item_id2` = 95687) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0003-028'))))) OR (((`item_id3` = 95687) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0003-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` = 95687 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |