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 | 761 | 761 | 245 | 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`.`item_speed` = 1 AND `Item`.`id` IN (12380, 12381, 12382, 28880, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35343, 35343, 44664, 44664, 44678, 44678, 44785, 44786, 44787, 44788, 44794, 44794, 44794, 45127, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 57730, 57731, 57732, 57733, 58222, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64542, 64565, 64565, 64566, 64566, 65295, 65296, 65297, 65297, 65298, 65309, 65309, 65313, 65313, 65352, 65353, 65353, 65359, 65360, 65360, 65361, 65363, 65364, 65364, 65365, 65809, 73614, 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, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 79229, 79229, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 81567, 81567, 81567, 81568, 81568, 81568, 81631, 81632, 81633, 81634, 81635, 81670, 81671, 81672, 84121, 84121, 84122, 84122, 84177, 84178, 84179, 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, 84930, 84984, 84984, 84984, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 85768, 85814, 85815, 87278, 87317, 87317, 87318, 87318, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87413, 87634, 87820, 87821, 87822, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88537, 88537, 89539, 90450, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 91045, 91117, 91389, 91481, 91483, 91493, 91494, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91795, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 92277, 92278, 92279, 92676, 92677, 92678, 93058, 93178, 93185, 93186, 93214, 93229, 93231, 93236, 93241, 93243, 93244, 93251, 93256, 93631, 93636, 93955, 94282, 94283, 94360, 94361, 94827, 94827, 95090, 95162, 95162, 95185, 95347, 95348, 95349, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95766, 95767, 95900, 95901, 95902, 95903, 96014, 96063, 96330, 96753, 96755, 96756, 96758, 96765, 96766, 96771, 96772, 97376, 97796, 97797, 97815, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98108, 98109, 98110, 98111, 98113, 98115, 98116, 98129, 98132, 98169, 98169, 98173, 98173, 98214, 98214, 98214, 98215, 98215, 98215, 98218, 98219, 98220, 98412, 98415, 98422, 98422, 98434, 98628, 98638, 98640, 98641, 98664, 98766, 98811, 98813, 98814, 98815, 98816, 98817, 98818, 98819, 98821, 98822, 99305, 99306, 99307, 99308, 99309, 99310, 99311, 99330, 99331, 99332, 99333, 99334, 99335, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99406, 99407, 99408, 99409, 99410, 99411, 99428, 99429, 99430, 99431, 99432, 99433, 99434, 99435, 99436, 99437, 99438, 99439, 99440, 99441, 99442, 99511, 99512, 99517, 99518, 99519, 99520, 99521, 99522, 99523, 99557, 99566) 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 (12380, 12381, 12382, 28880, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35343, 35343, 44664, 44664, 44678, 44678, 44785, 44786, 44787, 44788, 44794, 44794, 44794, 45127, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 57730, 57731, 57732, 57733, 58222, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 64542, 64565, 64565, 64566, 64566, 65295, 65296, 65297, 65297, 65298, 65309, 65309, 65313, 65313, 65352, 65353, 65353, 65359, 65360, 65360, 65361, 65363, 65364, 65364, 65365, 65809, 73614, 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, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 79229, 79229, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 81567, 81567, 81567, 81568, 81568, 81568, 81631, 81632, 81633, 81634, 81635, 81670, 81671, 81672, 84121, 84121, 84122, 84122, 84177, 84178, 84179, 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, 84930, 84984, 84984, 84984, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 85768, 85814, 85815, 87278, 87317, 87317, 87318, 87318, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87413, 87634, 87820, 87821, 87822, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88537, 88537, 89539, 90450, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 91045, 91117, 91389, 91481, 91483, 91493, 91494, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91795, 91870, 91871, 91872, 91873, 91874, 91875, 91876, 91877, 91878, 92277, 92278, 92279, 92676, 92677, 92678, 93058, 93178, 93185, 93186, 93214, 93229, 93231, 93236, 93241, 93243, 93244, 93251, 93256, 93631, 93636, 93955, 94282, 94283, 94360, 94361, 94827, 94827, 95090, 95162, 95162, 95185, 95347, 95348, 95349, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95766, 95767, 95900, 95901, 95902, 95903, 96014, 96063, 96330, 96753, 96755, 96756, 96758, 96765, 96766, 96771, 96772, 97376, 97796, 97797, 97815, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98108, 98109, 98110, 98111, 98113, 98115, 98116, 98129, 98132, 98169, 98169, 98173, 98173, 98214, 98214, 98214, 98215, 98215, 98215, 98218, 98219, 98220, 98412, 98415, 98422, 98422, 98434, 98628, 98638, 98640, 98641, 98664, 98766, 98811, 98813, 98814, 98815, 98816, 98817, 98818, 98819, 98821, 98822, 99305, 99306, 99307, 99308, 99309, 99310, 99311, 99330, 99331, 99332, 99333, 99334, 99335, 99340, 99341, 99342, 99343, 99403, 99404, 99405, 99406, 99407, 99408, 99409, 99410, 99411, 99428, 99429, 99430, 99431, 99432, 99433, 99434, 99435, 99436, 99437, 99438, 99439, 99440, 99441, 99442, 99511, 99512, 99517, 99518, 99519, 99520, 99521, 99522, 99523, 99557, 99566) 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` = 74242) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0490AB'))))) OR (((`item_id2` = 74242) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0490AB'))))) OR (((`item_id3` = 74242) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0490AB')))))) 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` = 74242 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1125-009'))))) OR (((`item_id2` = 87333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1125-009'))))) OR (((`item_id3` = 87333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1125-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` = 87333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97975) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0436-045'))))) OR (((`item_id2` = 97975) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0436-045'))))) OR (((`item_id3` = 97975) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0436-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` = 97975 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95735) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1342-009'))))) OR (((`item_id2` = 95735) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1342-009'))))) OR (((`item_id3` = 95735) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1342-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` = 95735 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 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` = 95696) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0004-044'))))) OR (((`item_id2` = 95696) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0004-044'))))) OR (((`item_id3` = 95696) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0004-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` = 95696 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97962) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1089-028'))))) OR (((`item_id2` = 97962) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1089-028'))))) OR (((`item_id3` = 97962) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1089-028')))))) 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` = 97962 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87336) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1125-006'))))) OR (((`item_id2` = 87336) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1125-006'))))) OR (((`item_id3` = 87336) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1125-006')))))) 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` = 87336 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97972) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0716-045'))))) OR (((`item_id2` = 97972) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0716-045'))))) OR (((`item_id3` = 97972) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0716-045')))))) 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` = 97972 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97971) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0716-028'))))) OR (((`item_id2` = 97971) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0716-028'))))) OR (((`item_id3` = 97971) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0716-028')))))) 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` = 97971 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97970) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0434-013'))))) OR (((`item_id2` = 97970) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0434-013'))))) OR (((`item_id3` = 97970) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0434-013')))))) 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` = 97970 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97969) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0434-045'))))) OR (((`item_id2` = 97969) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0434-045'))))) OR (((`item_id3` = 97969) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0434-045')))))) 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` = 97969 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97968) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0434-028'))))) OR (((`item_id2` = 97968) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0434-028'))))) OR (((`item_id3` = 97968) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0434-028')))))) 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` = 97968 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97967) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1089-013'))))) OR (((`item_id2` = 97967) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1089-013'))))) OR (((`item_id3` = 97967) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1089-013')))))) 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` = 97967 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97966) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1089-045'))))) OR (((`item_id2` = 97966) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1089-045'))))) OR (((`item_id3` = 97966) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1089-045')))))) 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` = 97966 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 | |