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 '%ボトル%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 920 | 920 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_speed` = 1 AND `Item`.`id` IN (35625, 35626, 35638, 35639, 35640, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 45501, 64547, 64547, 64637, 64637, 64638, 64638, 64639, 64639, 64649, 64651, 65198, 65199, 65209, 65209, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73820, 77315, 77316, 77642, 77642, 77643, 77643, 77644, 77644, 77662, 77663, 77668, 77668, 77669, 77670, 78065, 78066, 78067, 80035, 80583, 80584, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80734, 80735, 80736, 80737, 80804, 80804, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 82630, 82873, 82877, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83879, 83881, 83942, 84112, 84113, 84116, 84121, 84121, 84122, 84122, 84140, 84165, 84521, 84522, 84523, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84541, 84542, 84544, 84545, 84907, 84908, 84996, 84997, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85210, 85288, 85290, 85356, 85639, 85640, 85641, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85798, 86047, 86048, 86049, 86109, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87400, 87401, 87402, 87405, 87406, 87775, 87776, 87777, 87778, 87821, 87844, 87845, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87892, 87894, 87895, 87896, 87897, 87898, 87915, 87915, 87916, 87916, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 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, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88278, 88279, 88280, 89659, 89660, 89661, 89662, 90329, 90332, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91033, 91034, 91129, 91129, 91393, 91394, 91395, 91396, 91397, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91488, 91508, 91631, 91631, 91632, 91632, 91633, 91633, 91650, 91651, 91652, 91653, 91727, 91728, 91744, 91845, 91846, 91847, 92095, 92690, 92695, 92696, 92697, 92698, 92699, 92713, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 93939, 93942, 93949, 93955, 93972, 93979, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94349, 94350, 94359, 94364, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94459, 94460, 94461, 94462, 94473, 94474, 94475, 94476, 94477, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94513, 94514, 94518, 94519, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94709, 94710, 94711, 94712, 94713, 94714, 94755, 94756, 94831, 94850, 94851, 94863, 94864, 94865, 94866, 95084, 95121, 95145, 95146, 95147, 95213, 95214, 95215, 95268, 95269, 95270, 95271, 95340, 95341, 95342, 95343, 95344, 95345, 95346, 95359, 95359, 95377, 95415, 95416, 95418, 95419, 95420, 95432, 95432, 95433, 95433, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95598, 95599, 95600, 95601, 95654, 95655, 95658, 95659, 95660, 95661, 95664, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95774, 95774, 95777, 95780, 95781, 95782, 95784, 95784, 96410, 96411, 96412, 96413, 96456, 96467, 96538, 96539, 96540, 96542, 96543, 96593, 96666, 96668, 96749, 96968, 97175, 97275, 97276, 97277, 97360, 97360, 97362, 97375, 97376, 97386, 97387, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97665, 97666, 97667, 97682, 97683, 97684, 97685, 97686, 97687, 97691, 97719, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97793, 97797, 97808, 97862, 97863, 97864, 97865, 97866, 97867, 97913, 97914, 97915, 97916, 97917, 97928, 97928, 97929, 97930, 97931, 97932, 97938, 97939, 97940, 97941, 97942, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98112, 98113, 98122, 98123, 98152, 98158, 98159, 98160, 98161, 98425, 98426, 98453, 98585, 98586, 98587, 98588, 98593, 98594, 98595, 98596, 98597, 98598, 98605, 98606, 98607, 98608, 98621, 98628, 98630, 98651, 98764, 98808, 98848, 98977, 98978, 98979, 98980, 98981, 98990, 98991, 98992, 98993, 98994, 98999, 99000, 99001, 99007, 99008, 99009, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99021, 99022, 99023, 99024, 99025, 99026, 99093, 99104, 99105, 99406, 99422, 99423, 99424, 99425, 99426, 99534, 99535, 99536, 99537, 99538, 99539, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99547, 99548) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`item_speed` = 1 AND `Item`.`id` IN (35625, 35626, 35638, 35639, 35640, 44760, 44760, 44761, 44761, 44762, 44762, 44763, 44764, 45501, 64547, 64547, 64637, 64637, 64638, 64638, 64639, 64639, 64649, 64651, 65198, 65199, 65209, 65209, 73805, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73818, 73820, 77315, 77316, 77642, 77642, 77643, 77643, 77644, 77644, 77662, 77663, 77668, 77668, 77669, 77670, 78065, 78066, 78067, 80035, 80583, 80584, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80725, 80725, 80726, 80726, 80727, 80727, 80728, 80728, 80729, 80730, 80734, 80735, 80736, 80737, 80804, 80804, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 82630, 82873, 82877, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83879, 83881, 83942, 84112, 84113, 84116, 84121, 84121, 84122, 84122, 84140, 84165, 84521, 84522, 84523, 84524, 84525, 84526, 84528, 84529, 84530, 84531, 84532, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84541, 84542, 84544, 84545, 84907, 84908, 84996, 84997, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85210, 85288, 85290, 85356, 85639, 85640, 85641, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85798, 86047, 86048, 86049, 86109, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87400, 87401, 87402, 87405, 87406, 87775, 87776, 87777, 87778, 87821, 87844, 87845, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87892, 87894, 87895, 87896, 87897, 87898, 87915, 87915, 87916, 87916, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 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, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88278, 88279, 88280, 89659, 89660, 89661, 89662, 90329, 90332, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91033, 91034, 91129, 91129, 91393, 91394, 91395, 91396, 91397, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91471, 91472, 91473, 91474, 91475, 91476, 91488, 91508, 91631, 91631, 91632, 91632, 91633, 91633, 91650, 91651, 91652, 91653, 91727, 91728, 91744, 91845, 91846, 91847, 92095, 92690, 92695, 92696, 92697, 92698, 92699, 92713, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 93939, 93942, 93949, 93955, 93972, 93979, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94341, 94341, 94349, 94350, 94359, 94364, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94459, 94460, 94461, 94462, 94473, 94474, 94475, 94476, 94477, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94513, 94514, 94518, 94519, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94709, 94710, 94711, 94712, 94713, 94714, 94755, 94756, 94831, 94850, 94851, 94863, 94864, 94865, 94866, 95084, 95121, 95145, 95146, 95147, 95213, 95214, 95215, 95268, 95269, 95270, 95271, 95340, 95341, 95342, 95343, 95344, 95345, 95346, 95359, 95359, 95377, 95415, 95416, 95418, 95419, 95420, 95432, 95432, 95433, 95433, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95598, 95599, 95600, 95601, 95654, 95655, 95658, 95659, 95660, 95661, 95664, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95774, 95774, 95777, 95780, 95781, 95782, 95784, 95784, 96410, 96411, 96412, 96413, 96456, 96467, 96538, 96539, 96540, 96542, 96543, 96593, 96666, 96668, 96749, 96968, 97175, 97275, 97276, 97277, 97360, 97360, 97362, 97375, 97376, 97386, 97387, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97665, 97666, 97667, 97682, 97683, 97684, 97685, 97686, 97687, 97691, 97719, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97793, 97797, 97808, 97862, 97863, 97864, 97865, 97866, 97867, 97913, 97914, 97915, 97916, 97917, 97928, 97928, 97929, 97930, 97931, 97932, 97938, 97939, 97940, 97941, 97942, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98112, 98113, 98122, 98123, 98152, 98158, 98159, 98160, 98161, 98425, 98426, 98453, 98585, 98586, 98587, 98588, 98593, 98594, 98595, 98596, 98597, 98598, 98605, 98606, 98607, 98608, 98621, 98628, 98630, 98651, 98764, 98808, 98848, 98977, 98978, 98979, 98980, 98981, 98990, 98991, 98992, 98993, 98994, 98999, 99000, 99001, 99007, 99008, 99009, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99021, 99022, 99023, 99024, 99025, 99026, 99093, 99104, 99105, 99406, 99422, 99423, 99424, 99425, 99426, 99534, 99535, 99536, 99537, 99538, 99539, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99547, 99548) AND `item_rank` <> 3 | 1 | 1 | 2 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1824-044'))))) OR (((`item_id2` = 94652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1824-044'))))) OR (((`item_id3` = 94652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1824-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` = 94652 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 | 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` = 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` = 98593) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-006'))))) OR (((`item_id2` = 98593) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-006'))))) OR (((`item_id3` = 98593) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98593 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98608) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-028'))))) OR (((`item_id2` = 98608) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-028'))))) OR (((`item_id3` = 98608) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98608 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-011'))))) OR (((`item_id2` = 98607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-011'))))) OR (((`item_id3` = 98607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98606) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-009'))))) OR (((`item_id2` = 98606) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-009'))))) OR (((`item_id3` = 98606) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98606 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98621) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TT-0006-044'))))) OR (((`item_id2` = 98621) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TT-0006-044'))))) OR (((`item_id3` = 98621) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TT-0006-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` = 98621 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98605) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-006'))))) OR (((`item_id2` = 98605) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-006'))))) OR (((`item_id3` = 98605) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98605 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98588) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0032-044'))))) OR (((`item_id2` = 98588) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0032-044'))))) OR (((`item_id3` = 98588) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0032-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` = 98588 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98587) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0032-030'))))) OR (((`item_id2` = 98587) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0032-030'))))) OR (((`item_id3` = 98587) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0032-030')))))) 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` = 98587 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98586) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0032-009'))))) OR (((`item_id2` = 98586) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0032-009'))))) OR (((`item_id3` = 98586) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0032-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` = 98586 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98585) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0032-006'))))) OR (((`item_id2` = 98585) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0032-006'))))) OR (((`item_id3` = 98585) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0032-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` = 98585 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98598) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-045'))))) OR (((`item_id2` = 98598) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-045'))))) OR (((`item_id3` = 98598) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-045')))))) 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` = 98598 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98597) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-034'))))) OR (((`item_id2` = 98597) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-034'))))) OR (((`item_id3` = 98597) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-034')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98597 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98596) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-011'))))) OR (((`item_id2` = 98596) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-011'))))) OR (((`item_id3` = 98596) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98596 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 | |