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 '%100枚%') OR (`Item`.`item_name` Like '%100枚%') OR (`Item`.`item_figure` Like '%100枚%') OR (`Item`.`item_color` Like '%100枚%') OR (`Item`.`item_materials` Like '%100枚%') OR (`Item`.`item_note` Like '%100枚%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 1020 | 1020 | 541 | 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 (3829, 3829, 6064, 6163, 6164, 6514, 6514, 12380, 12381, 12382, 12965, 28880, 35416, 35417, 35420, 44174, 44174, 44175, 44175, 44794, 44794, 44794, 45127, 54029, 54030, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54087, 54089, 54090, 58154, 58156, 58156, 58157, 58158, 58369, 58370, 58371, 58372, 68215, 68215, 69846, 70203, 72923, 72924, 73029, 73030, 73031, 73051, 73051, 73056, 73154, 73154, 73187, 73187, 73767, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74382, 74383, 74384, 74385, 74446, 74753, 74753, 74753, 74754, 74754, 74754, 74764, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77315, 77316, 77330, 77331, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77712, 78053, 78054, 78065, 78066, 78067, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 80205, 80206, 80583, 80584, 80748, 80752, 80779, 80781, 80782, 80785, 80786, 80787, 81216, 81216, 81229, 81496, 81497, 81498, 81499, 81499, 81500, 83752, 83809, 83810, 83811, 83866, 83867, 83868, 83885, 83886, 83936, 84059, 84079, 84084, 84245, 84343, 84343, 84344, 84344, 84345, 84345, 84353, 84354, 84355, 84456, 84457, 84458, 84459, 84460, 84461, 84462, 84463, 84464, 84465, 84466, 84467, 84546, 84546, 84547, 84547, 84581, 84582, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85168, 85169, 85170, 85170, 85267, 85268, 85269, 85270, 85414, 85437, 85443, 85713, 85713, 85714, 85714, 85717, 85718, 85798, 87263, 87284, 87284, 87291, 87291, 87301, 87301, 87302, 87302, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87396, 87397, 87400, 87401, 87402, 87414, 87414, 87414, 87653, 87654, 87783, 87784, 87785, 87786, 87860, 87860, 87861, 87861, 88144, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88249, 88250, 88251, 88252, 88253, 88254, 88540, 88617, 88617, 88617, 88972, 89532, 89539, 89552, 89999, 90321, 90340, 90390, 90391, 90674, 90675, 90676, 90677, 90691, 90692, 90693, 90694, 91051, 91052, 91053, 91325, 91389, 91483, 91487, 91517, 91528, 91529, 91568, 91570, 91570, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91654, 91655, 91656, 91657, 91658, 91659, 91660, 91661, 91662, 91663, 91833, 91834, 91836, 91890, 92110, 92111, 92286, 92333, 92389, 92390, 92391, 92396, 92397, 92443, 92444, 92445, 92446, 92447, 92448, 92449, 92450, 92451, 92471, 92513, 92514, 92515, 92516, 92517, 92518, 92519, 92520, 92535, 92536, 92539, 92547, 92548, 92619, 92650, 92833, 92933, 92934, 92995, 92999, 93002, 93003, 93004, 93005, 93029, 93055, 93056, 93113, 93119, 93123, 93125, 93162, 93195, 93262, 93359, 93436, 93455, 93512, 93631, 93812, 93881, 93976, 93976, 93979, 93984, 94036, 94255, 94256, 94257, 94257, 94258, 94258, 94273, 94276, 94280, 94281, 94368, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94455, 94456, 94457, 94458, 94613, 94614, 94615, 94616, 94677, 94678, 94679, 94763, 94795, 94812, 94827, 94827, 95074, 95075, 95076, 95088, 95088, 95148, 95165, 95235, 95236, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95360, 95388, 95389, 95390, 95399, 95403, 95411, 95432, 95432, 95433, 95433, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95510, 95511, 95512, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95598, 95599, 95600, 95601, 95629, 95630, 95631, 95632, 95633, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95668, 95669, 95670, 95671, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95760, 95772, 95795, 95875, 95878, 95929, 95930, 95931, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95967, 95968, 95969, 95970, 95971, 95972, 96021, 96033, 96043, 96047, 96050, 96060, 96130, 96139, 96140, 96141, 96168, 96169, 96170, 96172, 96200, 96201, 96203, 96212, 96213, 96223, 96224, 96225, 96275, 96277, 96346, 96349, 96361, 96423, 96430, 96446, 96464, 96504, 96586, 96689, 96720, 96740, 96741, 96749, 96779, 96823, 96824, 96825, 96851, 96883, 97042, 97059, 97063, 97070, 97071, 97113, 97130, 97131, 97158, 97243, 97244, 97245, 97246, 97247, 97248, 97275, 97276, 97277, 97296, 97297, 97318, 97319, 97320, 97321, 97322, 97376, 97382, 97382, 97383, 97383, 97426, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 97708, 97709, 97710, 97711, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97788, 97794, 97794, 97799, 97813, 97817, 97822, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98127, 98128, 98146, 98146, 98147, 98147, 98162, 98177, 98177, 98425, 98430, 98431, 98443, 98443, 98453, 98454, 98455, 98464, 98468, 98469, 98476, 98486, 98529, 98530, 98531, 98532, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98621, 98631, 98632, 98633, 98634, 98662, 98663, 98691, 98692, 98749, 98756, 98757, 98764, 98769, 98777, 98778, 98779, 98781, 98782, 98785, 98786, 98796, 98812, 98834, 98868, 98869, 98870, 98875, 98903, 98906, 98907, 98927, 98947, 98948, 98953, 98954, 98955, 98956, 98957, 98958, 98959, 98964, 98965, 98966, 98967, 98968, 99112, 99113, 99114, 99141, 99142, 99144, 99146, 99148, 99150, 99178, 99186, 99218, 99219, 99220, 99227, 99228, 99229, 99230, 99231, 99232, 99245, 99249, 99250, 99293, 99294, 99295, 99296, 99303, 99318, 99326, 99376, 99377, 99378, 99379, 99380, 99381, 99382, 99383, 99403, 99404, 99405, 99412, 99459, 99460, 99461, 99462, 99477, 99502, 99503, 99504, 99505, 99506, 99511, 99512, 99547, 99548, 99557, 99583, 99642, 99643, 99644, 99645, 99646, 99647, 99648, 99649, 99652, 99663, 99664, 99665, 99666, 99667, 99668, 99669, 99670, 99671, 99698, 99713, 99715, 99723, 99744) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 4 | 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 (3829, 3829, 6064, 6163, 6164, 6514, 6514, 12380, 12381, 12382, 12965, 28880, 35416, 35417, 35420, 44174, 44174, 44175, 44175, 44794, 44794, 44794, 45127, 54029, 54030, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54087, 54089, 54090, 58154, 58156, 58156, 58157, 58158, 58369, 58370, 58371, 58372, 68215, 68215, 69846, 70203, 72923, 72924, 73029, 73030, 73031, 73051, 73051, 73056, 73154, 73154, 73187, 73187, 73767, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74382, 74383, 74384, 74385, 74446, 74753, 74753, 74753, 74754, 74754, 74754, 74764, 77039, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 77315, 77316, 77330, 77331, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77712, 78053, 78054, 78065, 78066, 78067, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 80205, 80206, 80583, 80584, 80748, 80752, 80779, 80781, 80782, 80785, 80786, 80787, 81216, 81216, 81229, 81496, 81497, 81498, 81499, 81499, 81500, 83752, 83809, 83810, 83811, 83866, 83867, 83868, 83885, 83886, 83936, 84059, 84079, 84084, 84245, 84343, 84343, 84344, 84344, 84345, 84345, 84353, 84354, 84355, 84456, 84457, 84458, 84459, 84460, 84461, 84462, 84463, 84464, 84465, 84466, 84467, 84546, 84546, 84547, 84547, 84581, 84582, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85168, 85169, 85170, 85170, 85267, 85268, 85269, 85270, 85414, 85437, 85443, 85713, 85713, 85714, 85714, 85717, 85718, 85798, 87263, 87284, 87284, 87291, 87291, 87301, 87301, 87302, 87302, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87396, 87397, 87400, 87401, 87402, 87414, 87414, 87414, 87653, 87654, 87783, 87784, 87785, 87786, 87860, 87860, 87861, 87861, 88144, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88249, 88250, 88251, 88252, 88253, 88254, 88540, 88617, 88617, 88617, 88972, 89532, 89539, 89552, 89999, 90321, 90340, 90390, 90391, 90674, 90675, 90676, 90677, 90691, 90692, 90693, 90694, 91051, 91052, 91053, 91325, 91389, 91483, 91487, 91517, 91528, 91529, 91568, 91570, 91570, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91654, 91655, 91656, 91657, 91658, 91659, 91660, 91661, 91662, 91663, 91833, 91834, 91836, 91890, 92110, 92111, 92286, 92333, 92389, 92390, 92391, 92396, 92397, 92443, 92444, 92445, 92446, 92447, 92448, 92449, 92450, 92451, 92471, 92513, 92514, 92515, 92516, 92517, 92518, 92519, 92520, 92535, 92536, 92539, 92547, 92548, 92619, 92650, 92833, 92933, 92934, 92995, 92999, 93002, 93003, 93004, 93005, 93029, 93055, 93056, 93113, 93119, 93123, 93125, 93162, 93195, 93262, 93359, 93436, 93455, 93512, 93631, 93812, 93881, 93976, 93976, 93979, 93984, 94036, 94255, 94256, 94257, 94257, 94258, 94258, 94273, 94276, 94280, 94281, 94368, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94455, 94456, 94457, 94458, 94613, 94614, 94615, 94616, 94677, 94678, 94679, 94763, 94795, 94812, 94827, 94827, 95074, 95075, 95076, 95088, 95088, 95148, 95165, 95235, 95236, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95360, 95388, 95389, 95390, 95399, 95403, 95411, 95432, 95432, 95433, 95433, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95510, 95511, 95512, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95598, 95599, 95600, 95601, 95629, 95630, 95631, 95632, 95633, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95668, 95669, 95670, 95671, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95760, 95772, 95795, 95875, 95878, 95929, 95930, 95931, 95957, 95958, 95959, 95960, 95961, 95962, 95963, 95967, 95968, 95969, 95970, 95971, 95972, 96021, 96033, 96043, 96047, 96050, 96060, 96130, 96139, 96140, 96141, 96168, 96169, 96170, 96172, 96200, 96201, 96203, 96212, 96213, 96223, 96224, 96225, 96275, 96277, 96346, 96349, 96361, 96423, 96430, 96446, 96464, 96504, 96586, 96689, 96720, 96740, 96741, 96749, 96779, 96823, 96824, 96825, 96851, 96883, 97042, 97059, 97063, 97070, 97071, 97113, 97130, 97131, 97158, 97243, 97244, 97245, 97246, 97247, 97248, 97275, 97276, 97277, 97296, 97297, 97318, 97319, 97320, 97321, 97322, 97376, 97382, 97382, 97383, 97383, 97426, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 97708, 97709, 97710, 97711, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97726, 97726, 97727, 97727, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97788, 97794, 97794, 97799, 97813, 97817, 97822, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98127, 98128, 98146, 98146, 98147, 98147, 98162, 98177, 98177, 98425, 98430, 98431, 98443, 98443, 98453, 98454, 98455, 98464, 98468, 98469, 98476, 98486, 98529, 98530, 98531, 98532, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98621, 98631, 98632, 98633, 98634, 98662, 98663, 98691, 98692, 98749, 98756, 98757, 98764, 98769, 98777, 98778, 98779, 98781, 98782, 98785, 98786, 98796, 98812, 98834, 98868, 98869, 98870, 98875, 98903, 98906, 98907, 98927, 98947, 98948, 98953, 98954, 98955, 98956, 98957, 98958, 98959, 98964, 98965, 98966, 98967, 98968, 99112, 99113, 99114, 99141, 99142, 99144, 99146, 99148, 99150, 99178, 99186, 99218, 99219, 99220, 99227, 99228, 99229, 99230, 99231, 99232, 99245, 99249, 99250, 99293, 99294, 99295, 99296, 99303, 99318, 99326, 99376, 99377, 99378, 99379, 99380, 99381, 99382, 99383, 99403, 99404, 99405, 99412, 99459, 99460, 99461, 99462, 99477, 99502, 99503, 99504, 99505, 99506, 99511, 99512, 99547, 99548, 99557, 99583, 99642, 99643, 99644, 99645, 99646, 99647, 99648, 99649, 99652, 99663, 99664, 99665, 99666, 99667, 99668, 99669, 99670, 99671, 99698, 99713, 99715, 99723, 99744) 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` = 95969) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25320G11C'))))) OR (((`item_id2` = 95969) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25320G11C'))))) OR (((`item_id3` = 95969) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25320G11C')))))) 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` = 95969 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25285G9A'))))) OR (((`item_id2` = 92517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25285G9A'))))) OR (((`item_id3` = 92517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25285G9A')))))) 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` = 92517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92995) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2535G5'))))) OR (((`item_id2` = 92995) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2535G5'))))) OR (((`item_id3` = 92995) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2535G5')))))) 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` = 92995 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91052) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372731'))))) OR (((`item_id2` = 91052) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372731'))))) OR (((`item_id3` = 91052) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372731')))))) 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` = 91052 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91053) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372741'))))) OR (((`item_id2` = 91053) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372741'))))) OR (((`item_id3` = 91053) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372741')))))) 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` = 91053 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91051) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2372721'))))) OR (((`item_id2` = 91051) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2372721'))))) OR (((`item_id3` = 91051) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2372721')))))) 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` = 91051 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94281) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-289446'))))) OR (((`item_id2` = 94281) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-289446'))))) OR (((`item_id3` = 94281) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-289446')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 94281 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95970) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25320G12A'))))) OR (((`item_id2` = 95970) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25320G12A'))))) OR (((`item_id3` = 95970) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25320G12A')))))) 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` = 95970 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 12965) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206849'))))) OR (((`item_id2` = 12965) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206849'))))) OR (((`item_id3` = 12965) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206849')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 12965 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1287-002'))))) OR (((`item_id2` = 77246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1287-002'))))) OR (((`item_id3` = 77246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1287-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` = 77246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98529) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0146-001'))))) OR (((`item_id2` = 98529) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0146-001'))))) OR (((`item_id3` = 98529) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0146-001')))))) 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` = 98529 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95634) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0140-001'))))) OR (((`item_id2` = 95634) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0140-001'))))) OR (((`item_id3` = 95634) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0140-001')))))) 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` = 95634 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25277G9D'))))) OR (((`item_id2` = 92516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25277G9D'))))) OR (((`item_id3` = 92516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25277G9D')))))) 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` = 92516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-034'))))) OR (((`item_id2` = 98579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-034'))))) OR (((`item_id3` = 98579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-034')))))) 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` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92539) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25318G3'))))) OR (((`item_id2` = 92539) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25318G3'))))) OR (((`item_id3` = 92539) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25318G3')))))) 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` = 92539 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 | |