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 | 820 | 820 | 407 | maybe slow |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (29196, 35252, 35260, 35269, 35270, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 36770, 44707, 45144, 45144, 48175, 48176, 54069, 57747, 64463, 64476, 64604, 64605, 64606, 64681, 65209, 65209, 65363, 65364, 65364, 65365, 68314, 68314, 73642, 73643, 73678, 73678, 73678, 73768, 73769, 73770, 73771, 73776, 73776, 73776, 73777, 73777, 73777, 73834, 74445, 74445, 74787, 74788, 76813, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77169, 77169, 77186, 77188, 77191, 77191, 77202, 77203, 77254, 77254, 77255, 77255, 77256, 77256, 77319, 77604, 77604, 77604, 77645, 77646, 77647, 77648, 77649, 77650, 77705, 77705, 78058, 79229, 79229, 79239, 79239, 79423, 79460, 80366, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81480, 81481, 81482, 81506, 81506, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81611, 81612, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81624, 81625, 81626, 81730, 81731, 82453, 82454, 82455, 82456, 83726, 83780, 83781, 83784, 83785, 83796, 83796, 83814, 83814, 83815, 83815, 83835, 83836, 83837, 83838, 83839, 83840, 84079, 84081, 84085, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84442, 84443, 84492, 84492, 84506, 84507, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84984, 84984, 84984, 85210, 85334, 85342, 85437, 85443, 85636, 85637, 85638, 85684, 85684, 85685, 85685, 85685, 85699, 85699, 85794, 85794, 85811, 85814, 85815, 86012, 86012, 86013, 86013, 86017, 86084, 86109, 86970, 87252, 87315, 87371, 87372, 87373, 87398, 87399, 87664, 87820, 87821, 87822, 87853, 87854, 87855, 87855, 87890, 87891, 87921, 88144, 88157, 88158, 88159, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88239, 88246, 88972, 89539, 90321, 90361, 90362, 90363, 90380, 90381, 90390, 90391, 90402, 90403, 90404, 90405, 90406, 90407, 90416, 90417, 90431, 90432, 90449, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90709, 90710, 90711, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90889, 90890, 90891, 90892, 90893, 90992, 90993, 90994, 90995, 90996, 90997, 90998, 90999, 91000, 91009, 91010, 91011, 91057, 91061, 91332, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91477, 91478, 91479, 91481, 91483, 91540, 91541, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91593, 91594, 91595, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 91610, 91611, 91628, 91629, 91630, 91664, 91665, 91666, 91671, 91672, 91673, 91744, 91804, 91805, 91806, 91807, 91808, 92076, 92395, 92396, 92397, 92524, 92659, 92690, 92696, 92713, 92729, 92730, 92731, 92732, 92804, 93040, 93041, 93046, 93154, 93214, 93216, 93229, 93267, 93300, 93301, 93302, 93320, 93321, 93322, 93323, 93324, 93325, 93471, 93940, 93972, 94036, 94421, 94421, 94421, 94422, 94422, 94422, 94423, 94423, 94423, 94424, 94424, 94424, 94473, 94474, 94475, 94476, 94477, 94493, 94495, 94496, 94562, 94653, 94654, 94655, 94656, 94657, 94658, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94680, 94681, 94682, 94703, 94799, 94812, 95086, 95099, 95129, 95219, 95220, 95221, 95222, 95223, 95224, 95228, 95229, 95230, 95241, 95246, 95247, 95248, 95265, 95266, 95267, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95347, 95348, 95349, 95361, 95367, 95399, 95403, 95432, 95432, 95433, 95433, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95591, 95592, 95593, 95594, 95622, 95623, 95624, 95625, 95626, 95664, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95734, 95735, 95736, 95737, 95738, 95780, 95781, 95820, 95821, 95822, 95924, 96040, 96204, 96227, 96316, 96320, 96425, 96468, 96504, 96767, 96772, 96809, 96810, 96813, 96943, 97054, 97106, 97178, 97179, 97180, 97375, 97387, 97606, 97615, 97615, 97616, 97616, 97625, 97719, 97807, 97808, 97815, 97850, 97851, 97852, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98037, 98038, 98039, 98040, 98041, 98065, 98066, 98067, 98068, 98069, 98214, 98214, 98214, 98215, 98215, 98215, 98432, 98442, 98442, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98467, 98472, 98476, 98477, 98478, 98503, 98504, 98505, 98506, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98609, 98610, 98611, 98675, 98818, 98899, 98900, 98901, 98902, 98903, 98927, 98955, 98956, 98974, 98975, 98976, 98977, 98978, 98995, 98996, 98997, 98998, 98999, 99000, 99001, 99007, 99008, 99009, 99015, 99016, 99017, 99021, 99022, 99023, 99024, 99025, 99026, 99049, 99050, 99051, 99052, 99138, 99156, 99163, 99188, 99283, 99293, 99294, 99295, 99296, 99299, 99314, 99370, 99417, 99418, 99419, 99420, 99447, 99449, 99525, 99527, 99549, 99572, 99726, 99727, 99728, 99729, 99732, 99737, 99738, 99739, 99740, 99742, 99748, 99765, 99766, 99767, 99768, 99769, 99770, 99780, 99781) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 4 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (29196, 35252, 35260, 35269, 35270, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 36770, 44707, 45144, 45144, 48175, 48176, 54069, 57747, 64463, 64476, 64604, 64605, 64606, 64681, 65209, 65209, 65363, 65364, 65364, 65365, 68314, 68314, 73642, 73643, 73678, 73678, 73678, 73768, 73769, 73770, 73771, 73776, 73776, 73776, 73777, 73777, 73777, 73834, 74445, 74445, 74787, 74788, 76813, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77169, 77169, 77186, 77188, 77191, 77191, 77202, 77203, 77254, 77254, 77255, 77255, 77256, 77256, 77319, 77604, 77604, 77604, 77645, 77646, 77647, 77648, 77649, 77650, 77705, 77705, 78058, 79229, 79229, 79239, 79239, 79423, 79460, 80366, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 81480, 81481, 81482, 81506, 81506, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81611, 81612, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81624, 81625, 81626, 81730, 81731, 82453, 82454, 82455, 82456, 83726, 83780, 83781, 83784, 83785, 83796, 83796, 83814, 83814, 83815, 83815, 83835, 83836, 83837, 83838, 83839, 83840, 84079, 84081, 84085, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84343, 84343, 84344, 84344, 84345, 84345, 84442, 84443, 84492, 84492, 84506, 84507, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84984, 84984, 84984, 85210, 85334, 85342, 85437, 85443, 85636, 85637, 85638, 85684, 85684, 85685, 85685, 85685, 85699, 85699, 85794, 85794, 85811, 85814, 85815, 86012, 86012, 86013, 86013, 86017, 86084, 86109, 86970, 87252, 87315, 87371, 87372, 87373, 87398, 87399, 87664, 87820, 87821, 87822, 87853, 87854, 87855, 87855, 87890, 87891, 87921, 88144, 88157, 88158, 88159, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88239, 88246, 88972, 89539, 90321, 90361, 90362, 90363, 90380, 90381, 90390, 90391, 90402, 90403, 90404, 90405, 90406, 90407, 90416, 90417, 90431, 90432, 90449, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90709, 90710, 90711, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90889, 90890, 90891, 90892, 90893, 90992, 90993, 90994, 90995, 90996, 90997, 90998, 90999, 91000, 91009, 91010, 91011, 91057, 91061, 91332, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91477, 91478, 91479, 91481, 91483, 91540, 91541, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91593, 91594, 91595, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 91610, 91611, 91628, 91629, 91630, 91664, 91665, 91666, 91671, 91672, 91673, 91744, 91804, 91805, 91806, 91807, 91808, 92076, 92395, 92396, 92397, 92524, 92659, 92690, 92696, 92713, 92729, 92730, 92731, 92732, 92804, 93040, 93041, 93046, 93154, 93214, 93216, 93229, 93267, 93300, 93301, 93302, 93320, 93321, 93322, 93323, 93324, 93325, 93471, 93940, 93972, 94036, 94421, 94421, 94421, 94422, 94422, 94422, 94423, 94423, 94423, 94424, 94424, 94424, 94473, 94474, 94475, 94476, 94477, 94493, 94495, 94496, 94562, 94653, 94654, 94655, 94656, 94657, 94658, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94680, 94681, 94682, 94703, 94799, 94812, 95086, 95099, 95129, 95219, 95220, 95221, 95222, 95223, 95224, 95228, 95229, 95230, 95241, 95246, 95247, 95248, 95265, 95266, 95267, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95347, 95348, 95349, 95361, 95367, 95399, 95403, 95432, 95432, 95433, 95433, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95591, 95592, 95593, 95594, 95622, 95623, 95624, 95625, 95626, 95664, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95734, 95735, 95736, 95737, 95738, 95780, 95781, 95820, 95821, 95822, 95924, 96040, 96204, 96227, 96316, 96320, 96425, 96468, 96504, 96767, 96772, 96809, 96810, 96813, 96943, 97054, 97106, 97178, 97179, 97180, 97375, 97387, 97606, 97615, 97615, 97616, 97616, 97625, 97719, 97807, 97808, 97815, 97850, 97851, 97852, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98037, 98038, 98039, 98040, 98041, 98065, 98066, 98067, 98068, 98069, 98214, 98214, 98214, 98215, 98215, 98215, 98432, 98442, 98442, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98467, 98472, 98476, 98477, 98478, 98503, 98504, 98505, 98506, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98609, 98610, 98611, 98675, 98818, 98899, 98900, 98901, 98902, 98903, 98927, 98955, 98956, 98974, 98975, 98976, 98977, 98978, 98995, 98996, 98997, 98998, 98999, 99000, 99001, 99007, 99008, 99009, 99015, 99016, 99017, 99021, 99022, 99023, 99024, 99025, 99026, 99049, 99050, 99051, 99052, 99138, 99156, 99163, 99188, 99283, 99293, 99294, 99295, 99296, 99299, 99314, 99370, 99417, 99418, 99419, 99420, 99447, 99449, 99525, 99527, 99549, 99572, 99726, 99727, 99728, 99729, 99732, 99737, 99738, 99739, 99740, 99742, 99748, 99765, 99766, 99767, 99768, 99769, 99770, 99780, 99781) AND `item_rank` <> 3 | 1 | 1 | 3 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) 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` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84984) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 's-wt1A-a'))))) OR (((`item_id2` = 84984) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 's-wt1A-a'))))) OR (((`item_id3` = 84984) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 's-wt1A-a')))))) 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` = 84984 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81625) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0952-009'))))) OR (((`item_id2` = 81625) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0952-009'))))) OR (((`item_id3` = 81625) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0952-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` = 81625 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79229) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G11'))))) OR (((`item_id2` = 79229) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G11'))))) OR (((`item_id3` = 79229) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G11')))))) 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` = 79229 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-034'))))) OR (((`item_id2` = 98579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-034'))))) OR (((`item_id3` = 98579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-034')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-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` = 98609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98504) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-011'))))) OR (((`item_id2` = 98504) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-011'))))) OR (((`item_id3` = 98504) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-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` = 98504 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98578) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-028'))))) OR (((`item_id2` = 98578) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-028'))))) OR (((`item_id3` = 98578) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-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` = 98578 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98503) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-008'))))) OR (((`item_id2` = 98503) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-008'))))) OR (((`item_id3` = 98503) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-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` = 98503 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1038-002'))))) OR (((`item_id2` = 84547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1038-002'))))) OR (((`item_id3` = 84547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1038-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` = 84547 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25272G7'))))) OR (((`item_id2` = 83726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25272G7'))))) OR (((`item_id3` = 83726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25272G7')))))) 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` = 83726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98577) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-009'))))) OR (((`item_id2` = 98577) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-009'))))) OR (((`item_id3` = 98577) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-009')))))) 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` = 98577 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98576) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0029-044'))))) OR (((`item_id2` = 98576) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0029-044'))))) OR (((`item_id3` = 98576) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0029-044')))))) 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` = 98576 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0151-044'))))) OR (((`item_id2` = 98516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0151-044'))))) OR (((`item_id3` = 98516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0151-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` = 98516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98575) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0029-034'))))) OR (((`item_id2` = 98575) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0029-034'))))) OR (((`item_id3` = 98575) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0029-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` = 98575 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 | |