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 '%[PC周辺グッズ]%') OR (`Item`.`item_name` Like '%[PC周辺グッズ]%') OR (`Item`.`item_figure` Like '%[PC周辺グッズ]%') OR (`Item`.`item_color` Like '%[PC周辺グッズ]%') OR (`Item`.`item_materials` Like '%[PC周辺グッズ]%') OR (`Item`.`item_note` Like '%[PC周辺グッズ]%') OR (`Item`.`item_code` Like '%USBデスクライト%') OR (`Item`.`item_name` Like '%USBデスクライト%') OR (`Item`.`item_figure` Like '%USBデスクライト%') OR (`Item`.`item_color` Like '%USBデスクライト%') OR (`Item`.`item_materials` Like '%USBデスクライト%') OR (`Item`.`item_note` Like '%USBデスクライト%') 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 | 1776 | 1776 | 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`.`item_rank` = 1 AND `Item`.`id` IN (6030, 6030, 6031, 6031, 6058, 6059, 6777, 6777, 6778, 6778, 6779, 6779, 12380, 12381, 12382, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34885, 34886, 34969, 34969, 34970, 34970, 34971, 34971, 35292, 35292, 35301, 35301, 35310, 35310, 35343, 35343, 35403, 35403, 35562, 35564, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35788, 35788, 38504, 38504, 44664, 44664, 44678, 44678, 44760, 44760, 44761, 44761, 44762, 44762, 44781, 44781, 45501, 45516, 45516, 45518, 45518, 45539, 45539, 54083, 54083, 54085, 54085, 54086, 54086, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58155, 58155, 58156, 58156, 58231, 58231, 58344, 58345, 58345, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64465, 64470, 64471, 64476, 64547, 64547, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64646, 64647, 64648, 64656, 64657, 64658, 64659, 64660, 64670, 64670, 64671, 64671, 64672, 64672, 65204, 65209, 65209, 65212, 65213, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65271, 65271, 65272, 65272, 65273, 65273, 65276, 65276, 65277, 65277, 65280, 65280, 65282, 65282, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65334, 65335, 65338, 65338, 65340, 65340, 65353, 65353, 65360, 65360, 65364, 65364, 68510, 71525, 71526, 73642, 73657, 73658, 73667, 73667, 73678, 73678, 73678, 73691, 73691, 73697, 73697, 73734, 73734, 73737, 73737, 73747, 73747, 73763, 73763, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73781, 73781, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73845, 73845, 73864, 73864, 73870, 73870, 74357, 74359, 74360, 74424, 74424, 74427, 74428, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74769, 74769, 74782, 74782, 77081, 77166, 77166, 77167, 77167, 77169, 77169, 77230, 77230, 77230, 77245, 77245, 77246, 77246, 77250, 77250, 77251, 77251, 77254, 77254, 77255, 77255, 77256, 77256, 77590, 77590, 77604, 77604, 77604, 77610, 77611, 77614, 77614, 77615, 77615, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77658, 77658, 77660, 77660, 77668, 77668, 77699, 77699, 77700, 77700, 77700, 77705, 77705, 77710, 77710, 77733, 77733, 77736, 77736, 77743, 77743, 80537, 80612, 80613, 80646, 80646, 80666, 80666, 80667, 80667, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80784, 80784, 80790, 80790, 80800, 80800, 80803, 80803, 80804, 80804, 80805, 81471, 81471, 81472, 81472, 81474, 81474, 81499, 81499, 81506, 81506, 81509, 81509, 81510, 81510, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81528, 81528, 81530, 81530, 81532, 81532, 81533, 81533, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81567, 81567, 81567, 81568, 81568, 81568, 81569, 81569, 81570, 81570, 81572, 81572, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81667, 81667, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83771, 83771, 83792, 83792, 83793, 83804, 83804, 83805, 83806, 83814, 83814, 83815, 83815, 83834, 83834, 83855, 83855, 83877, 83877, 83877, 83878, 83878, 83878, 83898, 83898, 83899, 83899, 84128, 84177, 84178, 84218, 84313, 84313, 84314, 84314, 84315, 84315, 84318, 84318, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84503, 84503, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84539, 84539, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84608, 84609, 84610, 84611, 84907, 84908, 85004, 85004, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85039, 85039, 85040, 85040, 85041, 85041, 85064, 85064, 85065, 85065, 85069, 85069, 85070, 85070, 85071, 85071, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85212, 85213, 85220, 85220, 85263, 85264, 85265, 85266, 85441, 85442, 85443, 85444, 85454, 85458, 85459, 85460, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85647, 85647, 85664, 85664, 85665, 85665, 85684, 85684, 85685, 85685, 85685, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85709, 85709, 85710, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85722, 85723, 85723, 85728, 85728, 85729, 85729, 85768, 85814, 85815, 86012, 86012, 86013, 86013, 86047, 86345, 86743, 86744, 86745, 86746, 87284, 87284, 87287, 87287, 87291, 87291, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87374, 87374, 87375, 87375, 87380, 87381, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87398, 87399, 87633, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87820, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87855, 87855, 87856, 87856, 87857, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87899, 87899, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87935, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 88150, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88208, 88208, 88208, 88228, 88228, 88229, 88229, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88238, 88238, 88238, 88265, 88283, 88283, 88644, 88645, 88647, 89011, 89489, 90021, 90397, 90397, 90429, 90429, 90430, 90430, 90449, 90450, 90456, 90456, 90457, 90467, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90702, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90803, 90804, 90805, 90806, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 91001, 91001, 91003, 91003, 91003, 91004, 91004, 91004, 91037, 91117, 91131, 91480, 91487, 91488, 91490, 91495, 91496, 91497, 91498, 91499, 91585, 91587, 91587, 91587, 91588, 91588, 91588, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91667, 91668, 91669, 91670, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91839, 91840, 91841, 91870, 91871, 91872, 91903, 91968, 91969, 91975, 91976, 91978, 92113, 92114, 92248, 92249, 92253, 92254, 92277, 92278, 92279, 92300, 92330, 92331, 92395, 92436, 92536, 92548, 92550, 92640, 92673, 92708, 92850, 92880, 92890, 92994, 93002, 93003, 93004, 93005, 93046, 93113, 93125, 93130, 93136, 93274, 93275, 93276, 93302, 93319, 93346, 93347, 93348, 93631, 93636, 93682, 93683, 93768, 93934, 93934, 94037, 94265, 94265, 94284, 94285, 94286, 94287, 94288, 94289, 94319, 94319, 94339, 94359, 94374, 94374, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94498, 94498, 94502, 94502, 94506, 94506, 94555, 94556, 94664, 94665, 94666, 94667, 94680, 94681, 94682, 94749, 94750, 94754, 94756, 94772, 94775, 94818, 94839, 94840, 94841, 95052, 95053, 95054, 95055, 95056, 95057, 95121, 95164, 95168, 95169, 95174, 95175, 95176, 95177, 95179, 95180, 95185, 95243, 95246, 95268, 95269, 95336, 95337, 95340, 95341, 95342, 95353, 95354, 95369, 95369, 95411, 95413, 95414, 95598, 95599, 95600, 95601, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95638, 95639, 95640, 95641, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95774, 95774, 95785, 95785, 95875, 95878, 95886, 95941, 95945, 95946, 95947, 95948, 95949, 95950, 95974, 95979, 95980, 95981, 95982, 95983, 96187, 96188, 96189, 96204, 96211, 96310, 96329, 96381, 96401, 96409, 96417, 96418, 96430, 96446, 96538, 96539, 96540, 96639, 96649, 96659, 96660, 96731, 96823, 96824, 96851, 96915, 96916, 96917, 96932, 96933, 97023, 97024, 97026, 97031, 97036, 97037, 97038, 97041, 97042, 97043, 97048, 97054, 97284, 97381, 97390, 97618, 97618, 97619, 97619, 97688, 97689, 97719, 97722, 97723, 97724, 97725, 97839, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 98050, 98050, 98050, 98051, 98051, 98051, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 98057, 98057, 98057, 98058, 98058, 98058, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98115, 98124, 98124, 98126, 98135, 98136, 98137, 98138, 98151, 98417, 98417, 98490, 98491, 98533, 98534, 98535, 98536, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98593, 98594, 98595, 98596, 98597, 98598, 98612, 98613, 98614, 98622, 98623, 98624, 98625, 98638, 98642, 98643, 98644, 98645, 98646, 98667, 98670, 98683, 98684, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98757, 98758, 98767, 98770, 98781, 98782, 98818, 98833, 98853, 98860, 98861, 98866, 98935, 98960, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99104, 99105, 99122, 99125, 99126, 99127, 99128, 99129, 99131, 99132, 99134, 99135, 99209, 99210, 99211, 99281, 99355, 99412, 99413, 99414, 99429, 99430, 99431, 99432, 99433, 99434, 99435, 99436, 99437, 99438, 99439, 99440, 99441, 99442, 99476, 99500, 99501, 99576, 99628, 99652) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 8 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_rank` = 1 AND `Item`.`id` IN (6030, 6030, 6031, 6031, 6058, 6059, 6777, 6777, 6778, 6778, 6779, 6779, 12380, 12381, 12382, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34885, 34886, 34969, 34969, 34970, 34970, 34971, 34971, 35292, 35292, 35301, 35301, 35310, 35310, 35343, 35343, 35403, 35403, 35562, 35564, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35788, 35788, 38504, 38504, 44664, 44664, 44678, 44678, 44760, 44760, 44761, 44761, 44762, 44762, 44781, 44781, 45501, 45516, 45516, 45518, 45518, 45539, 45539, 54083, 54083, 54085, 54085, 54086, 54086, 57650, 57650, 57651, 57651, 57652, 57652, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58155, 58155, 58156, 58156, 58231, 58231, 58344, 58345, 58345, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64465, 64470, 64471, 64476, 64547, 64547, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64646, 64647, 64648, 64656, 64657, 64658, 64659, 64660, 64670, 64670, 64671, 64671, 64672, 64672, 65204, 65209, 65209, 65212, 65213, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65271, 65271, 65272, 65272, 65273, 65273, 65276, 65276, 65277, 65277, 65280, 65280, 65282, 65282, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65334, 65335, 65338, 65338, 65340, 65340, 65353, 65353, 65360, 65360, 65364, 65364, 68510, 71525, 71526, 73642, 73657, 73658, 73667, 73667, 73678, 73678, 73678, 73691, 73691, 73697, 73697, 73734, 73734, 73737, 73737, 73747, 73747, 73763, 73763, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73781, 73781, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73845, 73845, 73864, 73864, 73870, 73870, 74357, 74359, 74360, 74424, 74424, 74427, 74428, 74753, 74753, 74753, 74754, 74754, 74754, 74768, 74768, 74769, 74769, 74782, 74782, 77081, 77166, 77166, 77167, 77167, 77169, 77169, 77230, 77230, 77230, 77245, 77245, 77246, 77246, 77250, 77250, 77251, 77251, 77254, 77254, 77255, 77255, 77256, 77256, 77590, 77590, 77604, 77604, 77604, 77610, 77611, 77614, 77614, 77615, 77615, 77616, 77616, 77617, 77617, 77631, 77631, 77632, 77632, 77658, 77658, 77660, 77660, 77668, 77668, 77699, 77699, 77700, 77700, 77700, 77705, 77705, 77710, 77710, 77733, 77733, 77736, 77736, 77743, 77743, 80537, 80612, 80613, 80646, 80646, 80666, 80666, 80667, 80667, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80692, 80692, 80693, 80693, 80704, 80704, 80706, 80706, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80784, 80784, 80790, 80790, 80800, 80800, 80803, 80803, 80804, 80804, 80805, 81471, 81471, 81472, 81472, 81474, 81474, 81499, 81499, 81506, 81506, 81509, 81509, 81510, 81510, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81528, 81528, 81530, 81530, 81532, 81532, 81533, 81533, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81567, 81567, 81567, 81568, 81568, 81568, 81569, 81569, 81570, 81570, 81572, 81572, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81667, 81667, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83771, 83771, 83792, 83792, 83793, 83804, 83804, 83805, 83806, 83814, 83814, 83815, 83815, 83834, 83834, 83855, 83855, 83877, 83877, 83877, 83878, 83878, 83878, 83898, 83898, 83899, 83899, 84128, 84177, 84178, 84218, 84313, 84313, 84314, 84314, 84315, 84315, 84318, 84318, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84492, 84492, 84493, 84493, 84494, 84494, 84495, 84495, 84503, 84503, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84539, 84539, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84593, 84593, 84594, 84594, 84595, 84595, 84595, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84608, 84609, 84610, 84611, 84907, 84908, 85004, 85004, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85039, 85039, 85040, 85040, 85041, 85041, 85064, 85064, 85065, 85065, 85069, 85069, 85070, 85070, 85071, 85071, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85208, 85208, 85209, 85209, 85212, 85213, 85220, 85220, 85263, 85264, 85265, 85266, 85441, 85442, 85443, 85444, 85454, 85458, 85459, 85460, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85647, 85647, 85664, 85664, 85665, 85665, 85684, 85684, 85685, 85685, 85685, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85709, 85709, 85710, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85722, 85723, 85723, 85728, 85728, 85729, 85729, 85768, 85814, 85815, 86012, 86012, 86013, 86013, 86047, 86345, 86743, 86744, 86745, 86746, 87284, 87284, 87287, 87287, 87291, 87291, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87374, 87374, 87375, 87375, 87380, 87381, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87398, 87399, 87633, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87820, 87844, 87845, 87850, 87850, 87851, 87851, 87851, 87855, 87855, 87856, 87856, 87857, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87899, 87899, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87935, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 88150, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88208, 88208, 88208, 88228, 88228, 88229, 88229, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88238, 88238, 88238, 88265, 88283, 88283, 88644, 88645, 88647, 89011, 89489, 90021, 90397, 90397, 90429, 90429, 90430, 90430, 90449, 90450, 90456, 90456, 90457, 90467, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90702, 90745, 90745, 90746, 90746, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90803, 90804, 90805, 90806, 90934, 90934, 90935, 90935, 90936, 90936, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 91001, 91001, 91003, 91003, 91003, 91004, 91004, 91004, 91037, 91117, 91131, 91480, 91487, 91488, 91490, 91495, 91496, 91497, 91498, 91499, 91585, 91587, 91587, 91587, 91588, 91588, 91588, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91667, 91668, 91669, 91670, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91839, 91840, 91841, 91870, 91871, 91872, 91903, 91968, 91969, 91975, 91976, 91978, 92113, 92114, 92248, 92249, 92253, 92254, 92277, 92278, 92279, 92300, 92330, 92331, 92395, 92436, 92536, 92548, 92550, 92640, 92673, 92708, 92850, 92880, 92890, 92994, 93002, 93003, 93004, 93005, 93046, 93113, 93125, 93130, 93136, 93274, 93275, 93276, 93302, 93319, 93346, 93347, 93348, 93631, 93636, 93682, 93683, 93768, 93934, 93934, 94037, 94265, 94265, 94284, 94285, 94286, 94287, 94288, 94289, 94319, 94319, 94339, 94359, 94374, 94374, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94498, 94498, 94502, 94502, 94506, 94506, 94555, 94556, 94664, 94665, 94666, 94667, 94680, 94681, 94682, 94749, 94750, 94754, 94756, 94772, 94775, 94818, 94839, 94840, 94841, 95052, 95053, 95054, 95055, 95056, 95057, 95121, 95164, 95168, 95169, 95174, 95175, 95176, 95177, 95179, 95180, 95185, 95243, 95246, 95268, 95269, 95336, 95337, 95340, 95341, 95342, 95353, 95354, 95369, 95369, 95411, 95413, 95414, 95598, 95599, 95600, 95601, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95638, 95639, 95640, 95641, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95774, 95774, 95785, 95785, 95875, 95878, 95886, 95941, 95945, 95946, 95947, 95948, 95949, 95950, 95974, 95979, 95980, 95981, 95982, 95983, 96187, 96188, 96189, 96204, 96211, 96310, 96329, 96381, 96401, 96409, 96417, 96418, 96430, 96446, 96538, 96539, 96540, 96639, 96649, 96659, 96660, 96731, 96823, 96824, 96851, 96915, 96916, 96917, 96932, 96933, 97023, 97024, 97026, 97031, 97036, 97037, 97038, 97041, 97042, 97043, 97048, 97054, 97284, 97381, 97390, 97618, 97618, 97619, 97619, 97688, 97689, 97719, 97722, 97723, 97724, 97725, 97839, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 98050, 98050, 98050, 98051, 98051, 98051, 98053, 98053, 98053, 98054, 98054, 98054, 98055, 98055, 98055, 98056, 98056, 98056, 98057, 98057, 98057, 98058, 98058, 98058, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98115, 98124, 98124, 98126, 98135, 98136, 98137, 98138, 98151, 98417, 98417, 98490, 98491, 98533, 98534, 98535, 98536, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98593, 98594, 98595, 98596, 98597, 98598, 98612, 98613, 98614, 98622, 98623, 98624, 98625, 98638, 98642, 98643, 98644, 98645, 98646, 98667, 98670, 98683, 98684, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 98757, 98758, 98767, 98770, 98781, 98782, 98818, 98833, 98853, 98860, 98861, 98866, 98935, 98960, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99104, 99105, 99122, 99125, 99126, 99127, 99128, 99129, 99131, 99132, 99134, 99135, 99209, 99210, 99211, 99281, 99355, 99412, 99413, 99414, 99429, 99430, 99431, 99432, 99433, 99434, 99435, 99436, 99437, 99438, 99439, 99440, 99441, 99442, 99476, 99500, 99501, 99576, 99628, 99652) AND `item_rank` <> 3 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64657) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0728-006'))))) OR (((`item_id2` = 64657) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0728-006'))))) OR (((`item_id3` = 64657) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0728-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` = 64657 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0890-043'))))) OR (((`item_id2` = 77736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0890-043'))))) OR (((`item_id3` = 77736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0890-043')))))) 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` = 77736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91680) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1233-028'))))) OR (((`item_id2` = 91680) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1233-028'))))) OR (((`item_id3` = 91680) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1233-028')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 91680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87935) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2708911'))))) OR (((`item_id2` = 87935) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2708911'))))) OR (((`item_id3` = 87935) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2708911')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 87935 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65353) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0435-043'))))) OR (((`item_id2` = 65353) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0435-043'))))) OR (((`item_id3` = 65353) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0435-043')))))) 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` = 65353 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81667) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-219146'))))) OR (((`item_id2` = 81667) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-219146'))))) OR (((`item_id3` = 81667) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-219146')))))) 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` = 81667 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85147) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1063-006'))))) OR (((`item_id2` = 85147) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1063-006'))))) OR (((`item_id3` = 85147) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1063-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` = 85147 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` = 87383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-009'))))) OR (((`item_id2` = 87383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-009'))))) OR (((`item_id3` = 87383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87383 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84313) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-238444'))))) OR (((`item_id2` = 84313) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-238444'))))) OR (((`item_id3` = 84313) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-238444')))))) 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` = 84313 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87384) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-044'))))) OR (((`item_id2` = 87384) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-044'))))) OR (((`item_id3` = 87384) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87384 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98594) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-008'))))) OR (((`item_id2` = 98594) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-008'))))) OR (((`item_id3` = 98594) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-008')))))) 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` = 98594 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98624) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0012-011'))))) OR (((`item_id2` = 98624) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0012-011'))))) OR (((`item_id3` = 98624) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0012-011')))))) 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` = 98624 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 | 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` = 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` = 98549) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-011'))))) OR (((`item_id2` = 98549) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-011'))))) OR (((`item_id3` = 98549) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-011')))))) 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` = 98549 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 | |