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 '%ピンク%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 938 | 938 | 454 | 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 `Campaign`.`id` IS NOT NULL AND `Item`.`id` IN (3829, 3829, 6514, 6514, 12382, 34907, 34970, 34970, 34982, 35105, 35179, 35180, 35188, 35189, 35190, 35252, 35254, 35286, 35292, 35292, 35295, 35301, 35301, 35304, 35310, 35310, 35343, 35343, 35403, 35403, 35639, 35673, 35760, 35760, 35764, 35764, 35788, 35788, 36242, 36243, 44174, 44174, 44175, 44175, 44664, 44664, 44678, 44678, 44682, 44685, 44689, 44693, 44698, 44703, 44785, 44786, 44787, 44788, 54051, 54051, 54058, 57650, 57650, 57651, 57651, 57652, 57652, 57686, 57686, 57709, 57731, 57747, 57748, 58130, 58156, 58156, 58178, 58227, 58231, 58231, 58234, 58344, 58349, 58349, 58372, 64430, 64438, 64439, 64444, 64445, 64445, 64446, 64446, 64447, 64447, 64451, 64452, 64453, 64596, 64630, 64630, 64631, 64631, 64646, 64656, 65033, 65033, 65204, 65238, 65268, 65268, 65271, 65271, 65274, 65277, 65277, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65338, 65338, 65353, 65353, 65360, 65360, 65364, 65364, 65809, 68101, 68102, 68103, 68305, 68335, 68335, 68346, 68347, 68348, 68349, 72479, 73667, 73667, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73734, 73734, 73737, 73737, 73763, 73763, 73764, 73766, 73767, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 73864, 73864, 73866, 73870, 73870, 73871, 74211, 74225, 74234, 74239, 74262, 74269, 74276, 74281, 74283, 74297, 74297, 74302, 74304, 74309, 74311, 74316, 74318, 74323, 74325, 74330, 74332, 74337, 74339, 74351, 74360, 74372, 74393, 74395, 74402, 74769, 74769, 76270, 77049, 77058, 77074, 77075, 77145, 77149, 77245, 77245, 77246, 77246, 77251, 77251, 77637, 77685, 77733, 77733, 77736, 77736, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78134, 78144, 80233, 80538, 80538, 80593, 80651, 80660, 80676, 80676, 80709, 80709, 80713, 80713, 80727, 80727, 80742, 80782, 80784, 80784, 80790, 80790, 80791, 81234, 81499, 81499, 81523, 81523, 81529, 81533, 81533, 81537, 81541, 81541, 81580, 81615, 81615, 81634, 82454, 82496, 83532, 83756, 83756, 83802, 83822, 83827, 83864, 83904, 83909, 83927, 83981, 84116, 84120, 84147, 84148, 84326, 84326, 84332, 84332, 84343, 84343, 84425, 84425, 84429, 84429, 84447, 84447, 84486, 84503, 84503, 84509, 84512, 84515, 84526, 84539, 84539, 84547, 84547, 84551, 84562, 84597, 84597, 84601, 84601, 84609, 84930, 84941, 85075, 85080, 85085, 85090, 85094, 85094, 85107, 85107, 85112, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85356, 85389, 85437, 85536, 85541, 85632, 85632, 85638, 85641, 85690, 86031, 86036, 86072, 86079, 86836, 86987, 87306, 87306, 87309, 87309, 87322, 87326, 87326, 87330, 87360, 87360, 87364, 87364, 87410, 87633, 87634, 87778, 87813, 87895, 87899, 87899, 87908, 87942, 87942, 87942, 88177, 88181, 88181, 88186, 88186, 88208, 88208, 88208, 88455, 88479, 88863, 88885, 89203, 89980, 89996, 90028, 90362, 90366, 90408, 90435, 90437, 90440, 90676, 90680, 90687, 90690, 90690, 90693, 90708, 90721, 90724, 90725, 90732, 90736, 90739, 90744, 90747, 90753, 90753, 90753, 90754, 90756, 90770, 90774, 90778, 90782, 90786, 90790, 90794, 90798, 90802, 90806, 90810, 90814, 90817, 90818, 90824, 90825, 90831, 90832, 90838, 90839, 90845, 90846, 90852, 90853, 90860, 90864, 90868, 90872, 90876, 90880, 90884, 90888, 90893, 90897, 90901, 90905, 90934, 90934, 90937, 90942, 90942, 90947, 90947, 90958, 90970, 90976, 90981, 90986, 90991, 90992, 90994, 90999, 91026, 91051, 91400, 91421, 91426, 91431, 91436, 91498, 91503, 91592, 91592, 91592, 91652, 91662, 91847, 91947, 91949, 92068, 92072, 92092, 92133, 92182, 92195, 92198, 92200, 92204, 92209, 92305, 92341, 92372, 92516, 92627, 92732, 92841, 92885, 92923, 93056, 93273, 93274, 93346, 93453, 93454, 93455, 93531, 93542, 93606, 93693, 93700, 93701, 93790, 93793, 93806, 93808, 93850, 93852, 93883, 93897, 93910, 93933, 93945, 93951, 93952, 94307, 94311, 94380, 94380, 94386, 94390, 94395, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94448, 94452, 94461, 94466, 94471, 94476, 94481, 94486, 94491, 94498, 94498, 94502, 94502, 94506, 94506, 94617, 94623, 94629, 94635, 94645, 94650, 94662, 94672, 94678, 94682, 94684, 94687, 94690, 94692, 94698, 94702, 94723, 94826, 94831, 94846, 94853, 94866, 95132, 95141, 95144, 95147, 95161, 95161, 95162, 95162, 95163, 95164, 95166, 95167, 95168, 95169, 95173, 95177, 95178, 95179, 95190, 95190, 95195, 95200, 95287, 95291, 95295, 95302, 95328, 95333, 95366, 95399, 95419, 95436, 95509, 95541, 95546, 95564, 95568, 95578, 95582, 95624, 95632, 95635, 95639, 95642, 95650, 95712, 95723, 95763, 95764, 95765, 95766, 95767, 95768, 95781, 95782, 95803, 95864, 95869, 95929, 95932, 95946, 95958, 95970, 95976, 95985, 96005, 96009, 96027, 96028, 96069, 96073, 96122, 96124, 96135, 96139, 96143, 96151, 96161, 96165, 96188, 96220, 96271, 96333, 96374, 96389, 96413, 96420, 96469, 96492, 96495, 96514, 96561, 96579, 96741, 96789, 96800, 96834, 96855, 96861, 96874, 96884, 96896, 96900, 96902, 96915, 96951, 96971, 97053, 97060, 97063, 97128, 97129, 97158, 97220, 97222, 97224, 97244, 97246, 97248, 97264, 97269, 97286, 97297, 97315, 97319, 97320, 97334, 97376, 97633, 97637, 97669, 97669, 97672, 97672, 97706, 97710, 97714, 97723, 97733, 97740, 97747, 97754, 97761, 97768, 97775, 97782, 97838, 97905, 97924, 97924, 97929, 97937, 97942, 97946, 97946, 97951, 97956, 97963, 97965, 97978, 97981, 98026, 98034, 98041, 98042, 98042, 98048, 98067, 98102, 98107, 98141, 98146, 98146, 98156, 98157, 98160, 98161, 98167, 98168, 98175, 98175, 98181, 98189, 98412, 98413, 98414, 98415, 98416, 98416, 98417, 98417, 98434, 98445, 98446, 98447, 98448, 98449, 98494, 98499, 98505, 98507, 98507, 98512, 98512, 98517, 98518, 98519, 98520, 98521, 98525, 98583, 98587, 98591, 98591, 98648, 98681, 98693, 98701, 98707, 98712, 98714, 98733, 98759, 98762, 98770, 98771, 98772, 98794, 98804, 98849, 98868, 98869, 98870, 98873, 98886, 98890, 98897, 98925, 98932, 98934, 98981, 98984, 98988, 98998, 99014, 99019, 99036, 99049, 99054, 99056, 99059, 99060, 99061, 99062, 99063, 99067, 99075, 99141, 99142, 99144, 99146, 99150, 99230, 99231, 99232, 99233, 99236, 99250, 99257, 99262, 99271, 99282, 99285, 99286, 99308, 99309, 99328, 99344, 99367, 99368, 99375, 99376, 99417, 99422, 99429, 99437, 99450, 99460, 99463, 99464, 99520, 99521, 99578, 99586, 99592, 99593, 99595, 99601, 99603, 99652, 99662, 99663, 99669, 99675, 99687, 99692, 99698, 99774, 99780, 99781) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc LIMIT 15 | 15 | 15 | 10 | 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 `Campaign`.`id` IS NOT NULL AND `Item`.`id` IN (3829, 3829, 6514, 6514, 12382, 34907, 34970, 34970, 34982, 35105, 35179, 35180, 35188, 35189, 35190, 35252, 35254, 35286, 35292, 35292, 35295, 35301, 35301, 35304, 35310, 35310, 35343, 35343, 35403, 35403, 35639, 35673, 35760, 35760, 35764, 35764, 35788, 35788, 36242, 36243, 44174, 44174, 44175, 44175, 44664, 44664, 44678, 44678, 44682, 44685, 44689, 44693, 44698, 44703, 44785, 44786, 44787, 44788, 54051, 54051, 54058, 57650, 57650, 57651, 57651, 57652, 57652, 57686, 57686, 57709, 57731, 57747, 57748, 58130, 58156, 58156, 58178, 58227, 58231, 58231, 58234, 58344, 58349, 58349, 58372, 64430, 64438, 64439, 64444, 64445, 64445, 64446, 64446, 64447, 64447, 64451, 64452, 64453, 64596, 64630, 64630, 64631, 64631, 64646, 64656, 65033, 65033, 65204, 65238, 65268, 65268, 65271, 65271, 65274, 65277, 65277, 65297, 65297, 65309, 65309, 65313, 65313, 65331, 65331, 65338, 65338, 65353, 65353, 65360, 65360, 65364, 65364, 65809, 68101, 68102, 68103, 68305, 68335, 68335, 68346, 68347, 68348, 68349, 72479, 73667, 73667, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73734, 73734, 73737, 73737, 73763, 73763, 73764, 73766, 73767, 73806, 73806, 73810, 73810, 73811, 73811, 73812, 73812, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73852, 73853, 73856, 73857, 73860, 73861, 73864, 73864, 73866, 73870, 73870, 73871, 74211, 74225, 74234, 74239, 74262, 74269, 74276, 74281, 74283, 74297, 74297, 74302, 74304, 74309, 74311, 74316, 74318, 74323, 74325, 74330, 74332, 74337, 74339, 74351, 74360, 74372, 74393, 74395, 74402, 74769, 74769, 76270, 77049, 77058, 77074, 77075, 77145, 77149, 77245, 77245, 77246, 77246, 77251, 77251, 77637, 77685, 77733, 77733, 77736, 77736, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78134, 78144, 80233, 80538, 80538, 80593, 80651, 80660, 80676, 80676, 80709, 80709, 80713, 80713, 80727, 80727, 80742, 80782, 80784, 80784, 80790, 80790, 80791, 81234, 81499, 81499, 81523, 81523, 81529, 81533, 81533, 81537, 81541, 81541, 81580, 81615, 81615, 81634, 82454, 82496, 83532, 83756, 83756, 83802, 83822, 83827, 83864, 83904, 83909, 83927, 83981, 84116, 84120, 84147, 84148, 84326, 84326, 84332, 84332, 84343, 84343, 84425, 84425, 84429, 84429, 84447, 84447, 84486, 84503, 84503, 84509, 84512, 84515, 84526, 84539, 84539, 84547, 84547, 84551, 84562, 84597, 84597, 84601, 84601, 84609, 84930, 84941, 85075, 85080, 85085, 85090, 85094, 85094, 85107, 85107, 85112, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85356, 85389, 85437, 85536, 85541, 85632, 85632, 85638, 85641, 85690, 86031, 86036, 86072, 86079, 86836, 86987, 87306, 87306, 87309, 87309, 87322, 87326, 87326, 87330, 87360, 87360, 87364, 87364, 87410, 87633, 87634, 87778, 87813, 87895, 87899, 87899, 87908, 87942, 87942, 87942, 88177, 88181, 88181, 88186, 88186, 88208, 88208, 88208, 88455, 88479, 88863, 88885, 89203, 89980, 89996, 90028, 90362, 90366, 90408, 90435, 90437, 90440, 90676, 90680, 90687, 90690, 90690, 90693, 90708, 90721, 90724, 90725, 90732, 90736, 90739, 90744, 90747, 90753, 90753, 90753, 90754, 90756, 90770, 90774, 90778, 90782, 90786, 90790, 90794, 90798, 90802, 90806, 90810, 90814, 90817, 90818, 90824, 90825, 90831, 90832, 90838, 90839, 90845, 90846, 90852, 90853, 90860, 90864, 90868, 90872, 90876, 90880, 90884, 90888, 90893, 90897, 90901, 90905, 90934, 90934, 90937, 90942, 90942, 90947, 90947, 90958, 90970, 90976, 90981, 90986, 90991, 90992, 90994, 90999, 91026, 91051, 91400, 91421, 91426, 91431, 91436, 91498, 91503, 91592, 91592, 91592, 91652, 91662, 91847, 91947, 91949, 92068, 92072, 92092, 92133, 92182, 92195, 92198, 92200, 92204, 92209, 92305, 92341, 92372, 92516, 92627, 92732, 92841, 92885, 92923, 93056, 93273, 93274, 93346, 93453, 93454, 93455, 93531, 93542, 93606, 93693, 93700, 93701, 93790, 93793, 93806, 93808, 93850, 93852, 93883, 93897, 93910, 93933, 93945, 93951, 93952, 94307, 94311, 94380, 94380, 94386, 94390, 94395, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94448, 94452, 94461, 94466, 94471, 94476, 94481, 94486, 94491, 94498, 94498, 94502, 94502, 94506, 94506, 94617, 94623, 94629, 94635, 94645, 94650, 94662, 94672, 94678, 94682, 94684, 94687, 94690, 94692, 94698, 94702, 94723, 94826, 94831, 94846, 94853, 94866, 95132, 95141, 95144, 95147, 95161, 95161, 95162, 95162, 95163, 95164, 95166, 95167, 95168, 95169, 95173, 95177, 95178, 95179, 95190, 95190, 95195, 95200, 95287, 95291, 95295, 95302, 95328, 95333, 95366, 95399, 95419, 95436, 95509, 95541, 95546, 95564, 95568, 95578, 95582, 95624, 95632, 95635, 95639, 95642, 95650, 95712, 95723, 95763, 95764, 95765, 95766, 95767, 95768, 95781, 95782, 95803, 95864, 95869, 95929, 95932, 95946, 95958, 95970, 95976, 95985, 96005, 96009, 96027, 96028, 96069, 96073, 96122, 96124, 96135, 96139, 96143, 96151, 96161, 96165, 96188, 96220, 96271, 96333, 96374, 96389, 96413, 96420, 96469, 96492, 96495, 96514, 96561, 96579, 96741, 96789, 96800, 96834, 96855, 96861, 96874, 96884, 96896, 96900, 96902, 96915, 96951, 96971, 97053, 97060, 97063, 97128, 97129, 97158, 97220, 97222, 97224, 97244, 97246, 97248, 97264, 97269, 97286, 97297, 97315, 97319, 97320, 97334, 97376, 97633, 97637, 97669, 97669, 97672, 97672, 97706, 97710, 97714, 97723, 97733, 97740, 97747, 97754, 97761, 97768, 97775, 97782, 97838, 97905, 97924, 97924, 97929, 97937, 97942, 97946, 97946, 97951, 97956, 97963, 97965, 97978, 97981, 98026, 98034, 98041, 98042, 98042, 98048, 98067, 98102, 98107, 98141, 98146, 98146, 98156, 98157, 98160, 98161, 98167, 98168, 98175, 98175, 98181, 98189, 98412, 98413, 98414, 98415, 98416, 98416, 98417, 98417, 98434, 98445, 98446, 98447, 98448, 98449, 98494, 98499, 98505, 98507, 98507, 98512, 98512, 98517, 98518, 98519, 98520, 98521, 98525, 98583, 98587, 98591, 98591, 98648, 98681, 98693, 98701, 98707, 98712, 98714, 98733, 98759, 98762, 98770, 98771, 98772, 98794, 98804, 98849, 98868, 98869, 98870, 98873, 98886, 98890, 98897, 98925, 98932, 98934, 98981, 98984, 98988, 98998, 99014, 99019, 99036, 99049, 99054, 99056, 99059, 99060, 99061, 99062, 99063, 99067, 99075, 99141, 99142, 99144, 99146, 99150, 99230, 99231, 99232, 99233, 99236, 99250, 99257, 99262, 99271, 99282, 99285, 99286, 99308, 99309, 99328, 99344, 99367, 99368, 99375, 99376, 99417, 99422, 99429, 99437, 99450, 99460, 99463, 99464, 99520, 99521, 99578, 99586, 99592, 99593, 99595, 99601, 99603, 99652, 99662, 99663, 99669, 99675, 99687, 99692, 99698, 99774, 99780, 99781) AND `item_rank` <> 3 | 1 | 1 | 6 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96495) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25323G6A'))))) OR (((`item_id2` = 96495) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25323G6A'))))) OR (((`item_id3` = 96495) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25323G6A')))))) 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` = 96495 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 68101) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25303G7A'))))) OR (((`item_id2` = 68101) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25303G7A'))))) OR (((`item_id3` = 68101) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25303G7A')))))) 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` = 68101 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84509) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1545-002'))))) OR (((`item_id2` = 84509) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1545-002'))))) OR (((`item_id3` = 84509) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1545-002')))))) 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` = 84509 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98041) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0895-040'))))) OR (((`item_id2` = 98041) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0895-040'))))) OR (((`item_id3` = 98041) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0895-040')))))) 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` = 98041 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97733) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0007-040'))))) OR (((`item_id2` = 97733) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0007-040'))))) OR (((`item_id3` = 97733) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0007-040')))))) 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` = 97733 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90440) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-2003-030'))))) OR (((`item_id2` = 90440) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-2003-030'))))) OR (((`item_id3` = 90440) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-2003-030')))))) 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` = 90440 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90680) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1731-030'))))) OR (((`item_id2` = 90680) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1731-030'))))) OR (((`item_id3` = 90680) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1731-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` = 90680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95635) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0140-002'))))) OR (((`item_id2` = 95635) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0140-002'))))) OR (((`item_id3` = 95635) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0140-002')))))) 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` = 95635 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96874) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25267G6A'))))) OR (((`item_id2` = 96874) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25267G6A'))))) OR (((`item_id3` = 96874) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25267G6A')))))) 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` = 96874 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90408) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1307-002'))))) OR (((`item_id2` = 90408) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1307-002'))))) OR (((`item_id3` = 90408) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1307-002')))))) 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` = 90408 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90958) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1719-040'))))) OR (((`item_id2` = 90958) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1719-040'))))) OR (((`item_id3` = 90958) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1719-040')))))) 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` = 90958 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95141) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1846-030'))))) OR (((`item_id2` = 95141) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1846-030'))))) OR (((`item_id3` = 95141) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1846-030')))))) 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` = 95141 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1823-040'))))) OR (((`item_id2` = 94645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1823-040'))))) OR (((`item_id3` = 94645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1823-040')))))) 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` = 94645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35673) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0311-002'))))) OR (((`item_id2` = 35673) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0311-002'))))) OR (((`item_id3` = 35673) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0311-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` = 35673 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97672) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-310348'))))) OR (((`item_id2` = 97672) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-310348'))))) OR (((`item_id3` = 97672) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-310348')))))) 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` = 97672 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 | |