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 | 709 | 709 | 366 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_rank` = 1 AND `Item`.`id` IN (6064, 6173, 36242, 36243, 36244, 36245, 36246, 44794, 44794, 44794, 54036, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 58128, 58129, 58130, 58131, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64440, 64441, 64441, 64442, 64443, 64443, 64444, 64448, 64449, 64450, 64451, 64452, 64453, 64462, 64465, 64470, 64471, 64472, 64473, 64473, 64475, 64475, 64476, 64480, 64486, 64486, 64486, 64542, 64549, 64550, 64556, 64556, 64557, 64557, 64558, 64558, 64565, 64565, 64566, 64566, 64582, 65720, 65721, 65722, 73613, 73614, 73643, 73647, 73650, 73650, 73651, 73651, 74201, 74203, 74205, 74206, 74208, 74209, 74210, 74211, 74212, 74213, 74215, 74217, 74219, 74220, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74238, 74239, 74240, 74241, 74242, 74243, 74245, 74247, 74249, 74250, 74251, 74252, 74256, 74257, 74259, 74262, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74280, 74281, 74282, 74283, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74432, 74439, 74440, 74446, 74450, 74764, 74765, 74766, 74767, 74768, 74768, 74769, 74769, 77327, 77329, 77330, 77331, 77332, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 80810, 80811, 80812, 80813, 81215, 81216, 81216, 81229, 81667, 81667, 81670, 81671, 81672, 81730, 81731, 83936, 83969, 83978, 83979, 83980, 83981, 84019, 84097, 84263, 84286, 84313, 84313, 84314, 84314, 84315, 84315, 84317, 84318, 84318, 84319, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 84911, 84911, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270, 85333, 85334, 85336, 85399, 85404, 85412, 85728, 85728, 85729, 85729, 85794, 85794, 85798, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 87246, 87246, 87263, 87633, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87724, 87725, 87726, 87727, 87728, 87729, 87730, 87731, 87740, 87741, 87742, 87743, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87748, 87749, 87750, 87751, 87752, 87753, 87754, 87755, 87756, 87757, 87758, 87759, 87760, 87921, 88150, 88157, 88158, 88537, 88537, 90323, 90323, 90329, 90340, 90353, 90354, 90356, 90451, 90451, 90452, 90452, 90456, 90456, 90457, 90461, 90461, 90462, 90463, 90463, 91045, 91057, 91061, 91068, 91070, 91070, 91325, 91332, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91480, 91487, 91488, 91490, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91511, 91512, 91517, 91528, 91529, 91733, 91734, 91735, 91736, 92552, 92823, 93748, 93966, 93968, 93969, 93969, 93976, 93976, 93985, 93986, 93987, 93988, 93989, 93990, 94021, 94255, 94256, 94257, 94257, 94258, 94258, 94264, 94264, 94265, 94265, 94279, 94280, 94281, 94282, 94283, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94317, 94318, 94318, 94319, 94319, 94563, 94564, 94755, 94756, 94757, 94758, 94759, 94761, 94775, 94809, 95070, 95070, 95071, 95071, 95072, 95072, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95086, 95090, 95097, 95098, 95347, 95348, 95349, 95350, 95352, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95371, 95374, 95375, 95388, 95389, 95390, 95410, 95421, 95422, 95423, 96146, 96148, 96149, 96150, 97358, 97359, 97360, 97360, 97362, 97366, 97366, 97369, 97377, 97377, 97379, 97382, 97382, 97388, 97389, 97607, 97608, 97609, 97610, 97611, 97612, 97613, 97614, 97615, 97615, 97616, 97616, 97625, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97682, 97683, 97684, 97685, 97686, 97687, 97688, 97689, 97690, 97691, 97692, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97793, 97794, 97794, 97795, 97796, 97797, 97798, 97802, 97803, 97804, 97806, 97807, 97808, 97809, 97810, 97812, 97813, 97819, 97820, 97821, 97829, 97835, 97836, 98444, 98453, 98455, 98486, 98487, 98488, 98705, 98706, 99362, 99363) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 15 | 15 | 15 | 7 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_rank` = 1 AND `Item`.`id` IN (6064, 6173, 36242, 36243, 36244, 36245, 36246, 44794, 44794, 44794, 54036, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 58128, 58129, 58130, 58131, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64440, 64441, 64441, 64442, 64443, 64443, 64444, 64448, 64449, 64450, 64451, 64452, 64453, 64462, 64465, 64470, 64471, 64472, 64473, 64473, 64475, 64475, 64476, 64480, 64486, 64486, 64486, 64542, 64549, 64550, 64556, 64556, 64557, 64557, 64558, 64558, 64565, 64565, 64566, 64566, 64582, 65720, 65721, 65722, 73613, 73614, 73643, 73647, 73650, 73650, 73651, 73651, 74201, 74203, 74205, 74206, 74208, 74209, 74210, 74211, 74212, 74213, 74215, 74217, 74219, 74220, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74238, 74239, 74240, 74241, 74242, 74243, 74245, 74247, 74249, 74250, 74251, 74252, 74256, 74257, 74259, 74262, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74280, 74281, 74282, 74283, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74347, 74348, 74349, 74350, 74351, 74352, 74353, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74432, 74439, 74440, 74446, 74450, 74764, 74765, 74766, 74767, 74768, 74768, 74769, 74769, 77327, 77329, 77330, 77331, 77332, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 80810, 80811, 80812, 80813, 81215, 81216, 81216, 81229, 81667, 81667, 81670, 81671, 81672, 81730, 81731, 83936, 83969, 83978, 83979, 83980, 83981, 84019, 84097, 84263, 84286, 84313, 84313, 84314, 84314, 84315, 84315, 84317, 84318, 84318, 84319, 84321, 84321, 84322, 84322, 84323, 84323, 84326, 84326, 84327, 84327, 84328, 84328, 84329, 84332, 84332, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 84911, 84911, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270, 85333, 85334, 85336, 85399, 85404, 85412, 85728, 85728, 85729, 85729, 85794, 85794, 85798, 86012, 86012, 86013, 86013, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 87246, 87246, 87263, 87633, 87702, 87702, 87702, 87722, 87722, 87723, 87723, 87724, 87725, 87726, 87727, 87728, 87729, 87730, 87731, 87740, 87741, 87742, 87743, 87744, 87744, 87745, 87745, 87746, 87746, 87747, 87747, 87747, 87748, 87749, 87750, 87751, 87752, 87753, 87754, 87755, 87756, 87757, 87758, 87759, 87760, 87921, 88150, 88157, 88158, 88537, 88537, 90323, 90323, 90329, 90340, 90353, 90354, 90356, 90451, 90451, 90452, 90452, 90456, 90456, 90457, 90461, 90461, 90462, 90463, 90463, 91045, 91057, 91061, 91068, 91070, 91070, 91325, 91332, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91480, 91487, 91488, 91490, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91511, 91512, 91517, 91528, 91529, 91733, 91734, 91735, 91736, 92552, 92823, 93748, 93966, 93968, 93969, 93969, 93976, 93976, 93985, 93986, 93987, 93988, 93989, 93990, 94021, 94255, 94256, 94257, 94257, 94258, 94258, 94264, 94264, 94265, 94265, 94279, 94280, 94281, 94282, 94283, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94317, 94318, 94318, 94319, 94319, 94563, 94564, 94755, 94756, 94757, 94758, 94759, 94761, 94775, 94809, 95070, 95070, 95071, 95071, 95072, 95072, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95086, 95090, 95097, 95098, 95347, 95348, 95349, 95350, 95352, 95353, 95354, 95355, 95356, 95357, 95359, 95359, 95360, 95371, 95374, 95375, 95388, 95389, 95390, 95410, 95421, 95422, 95423, 96146, 96148, 96149, 96150, 97358, 97359, 97360, 97360, 97362, 97366, 97366, 97369, 97377, 97377, 97379, 97382, 97382, 97388, 97389, 97607, 97608, 97609, 97610, 97611, 97612, 97613, 97614, 97615, 97615, 97616, 97616, 97625, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97682, 97683, 97684, 97685, 97686, 97687, 97688, 97689, 97690, 97691, 97692, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97793, 97794, 97794, 97795, 97796, 97797, 97798, 97802, 97803, 97804, 97806, 97807, 97808, 97809, 97810, 97812, 97813, 97819, 97820, 97821, 97829, 97835, 97836, 98444, 98453, 98455, 98486, 98487, 98488, 98705, 98706, 99362, 99363) 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` = 80810) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206542'))))) OR (((`item_id2` = 80810) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206542'))))) OR (((`item_id3` = 80810) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206542')))))) 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` = 80810 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6173) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h144-033445'))))) OR (((`item_id2` = 6173) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h144-033445'))))) OR (((`item_id3` = 6173) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h144-033445')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 6173 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6064) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h015-030246'))))) OR (((`item_id2` = 6064) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h015-030246'))))) OR (((`item_id3` = 6064) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h015-030246')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 6064 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36245) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h346-075346'))))) OR (((`item_id2` = 36245) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h346-075346'))))) OR (((`item_id3` = 36245) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h346-075346')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 36245 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74310) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0820AS'))))) OR (((`item_id2` = 74310) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0820AS'))))) OR (((`item_id3` = 74310) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0820AS')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 74310 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74439) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-041747FC'))))) OR (((`item_id2` = 74439) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-041747FC'))))) OR (((`item_id3` = 74439) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-041747FC')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 74439 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74298) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0920NB'))))) OR (((`item_id2` = 74298) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0920NB'))))) OR (((`item_id3` = 74298) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0920NB')))))) 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` = 74298 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74440) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-041846FC'))))) OR (((`item_id2` = 74440) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-041846FC'))))) OR (((`item_id3` = 74440) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-041846FC')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 74440 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74291) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0911AB'))))) OR (((`item_id2` = 74291) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0911AB'))))) OR (((`item_id3` = 74291) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0911AB')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 74291 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54053) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-100840'))))) OR (((`item_id2` = 54053) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-100840'))))) OR (((`item_id3` = 54053) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-100840')))))) 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` = 54053 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 44794) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-WT5'))))) OR (((`item_id2` = 44794) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-WT5'))))) OR (((`item_id3` = 44794) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-WT5')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 44794 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36246) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h346-075445'))))) OR (((`item_id2` = 36246) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h346-075445'))))) OR (((`item_id3` = 36246) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h346-075445')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 36246 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78159) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-WT1FC'))))) OR (((`item_id2` = 78159) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-WT1FC'))))) OR (((`item_id3` = 78159) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-WT1FC')))))) 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` = 78159 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74303) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0920NJ'))))) OR (((`item_id2` = 74303) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0920NJ'))))) OR (((`item_id3` = 74303) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0920NJ')))))) 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` = 74303 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36242) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h346-075049'))))) OR (((`item_id2` = 36242) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h346-075049'))))) OR (((`item_id3` = 36242) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h346-075049')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 36242 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |