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 '%USB%') OR (`Item`.`item_name` Like '%USB%') OR (`Item`.`item_figure` Like '%USB%') OR (`Item`.`item_color` Like '%USB%') OR (`Item`.`item_materials` Like '%USB%') OR (`Item`.`item_note` Like '%USB%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 323 | 323 | 286 | 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 (48175, 48176, 65209, 65209, 68510, 73657, 73658, 77219, 77220, 77225, 77225, 77270, 77271, 77590, 77590, 77610, 77611, 77616, 77616, 77617, 77617, 78017, 78018, 78019, 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, 80704, 80704, 81552, 81553, 81554, 81555, 81556, 81558, 83752, 83780, 83781, 83782, 83783, 84468, 84469, 84470, 84471, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85445, 86096, 87374, 87374, 87375, 87375, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 88204, 88205, 88206, 88207, 88283, 88283, 88685, 88905, 88972, 89766, 89766, 90368, 90369, 90416, 90417, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 91007, 91008, 91012, 91118, 91320, 91321, 91322, 91322, 91487, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91759, 91783, 91785, 91790, 91791, 91886, 91891, 91969, 91977, 91978, 92093, 92094, 92110, 92747, 92749, 92988, 92989, 92991, 93016, 93506, 94253, 94253, 94254, 94254, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94365, 94365, 94370, 94371, 94427, 94427, 94427, 94428, 94428, 94428, 94555, 94556, 94557, 94558, 94559, 94595, 94595, 94596, 94596, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94828, 94828, 94830, 94830, 95434, 95435, 95436, 95437, 96387, 96388, 96389, 96390, 96392, 96393, 96401, 96445, 96450, 96641, 96664, 96718, 96719, 96720, 96779, 97378, 97383, 97383, 97617, 97618, 97618, 97619, 97619, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97840, 97841, 97842, 98117, 98117, 98118, 98118, 98148, 98148, 98149, 98149, 98153, 98418, 98418, 98647, 98648, 98679, 98680, 98681, 98683, 98684, 98685, 98686, 98687, 98731, 98732, 98733, 98734, 98738, 98756, 98757, 98758, 98776, 98867, 98932, 98949, 98950, 98969, 98970, 99287, 99288, 99289, 99290, 99292, 99358, 99444, 99555, 99556) 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`.`id` IN (48175, 48176, 65209, 65209, 68510, 73657, 73658, 77219, 77220, 77225, 77225, 77270, 77271, 77590, 77590, 77610, 77611, 77616, 77616, 77617, 77617, 78017, 78018, 78019, 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, 80704, 80704, 81552, 81553, 81554, 81555, 81556, 81558, 83752, 83780, 83781, 83782, 83783, 84468, 84469, 84470, 84471, 85210, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85445, 86096, 87374, 87374, 87375, 87375, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87851, 87851, 87851, 87852, 87906, 87907, 87908, 88204, 88205, 88206, 88207, 88283, 88283, 88685, 88905, 88972, 89766, 89766, 90368, 90369, 90416, 90417, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 91007, 91008, 91012, 91118, 91320, 91321, 91322, 91322, 91487, 91589, 91589, 91589, 91590, 91590, 91590, 91591, 91591, 91591, 91592, 91592, 91592, 91759, 91783, 91785, 91790, 91791, 91886, 91891, 91969, 91977, 91978, 92093, 92094, 92110, 92747, 92749, 92988, 92989, 92991, 93016, 93506, 94253, 94253, 94254, 94254, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94339, 94365, 94365, 94370, 94371, 94427, 94427, 94427, 94428, 94428, 94428, 94555, 94556, 94557, 94558, 94559, 94595, 94595, 94596, 94596, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94727, 94727, 94727, 94728, 94728, 94728, 94729, 94729, 94729, 94730, 94730, 94730, 94828, 94828, 94830, 94830, 95434, 95435, 95436, 95437, 96387, 96388, 96389, 96390, 96392, 96393, 96401, 96445, 96450, 96641, 96664, 96718, 96719, 96720, 96779, 97378, 97383, 97383, 97617, 97618, 97618, 97619, 97619, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97840, 97841, 97842, 98117, 98117, 98118, 98118, 98148, 98148, 98149, 98149, 98153, 98418, 98418, 98647, 98648, 98679, 98680, 98681, 98683, 98684, 98685, 98686, 98687, 98731, 98732, 98733, 98734, 98738, 98756, 98757, 98758, 98776, 98867, 98932, 98949, 98950, 98969, 98970, 99287, 99288, 99289, 99290, 99292, 99358, 99444, 99555, 99556) 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` = 94599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1843-044'))))) OR (((`item_id2` = 94599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1843-044'))))) OR (((`item_id3` = 94599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1843-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` = 94599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97378) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2392250'))))) OR (((`item_id2` = 97378) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2392250'))))) OR (((`item_id3` = 97378) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2392250')))))) 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` = 97378 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98418) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36222'))))) OR (((`item_id2` = 98418) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36222'))))) OR (((`item_id3` = 98418) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36222')))))) 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` = 98418 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98118) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35868'))))) OR (((`item_id2` = 98118) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35868'))))) OR (((`item_id3` = 98118) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35868')))))) 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` = 98118 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98117) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36098'))))) OR (((`item_id2` = 98117) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36098'))))) OR (((`item_id3` = 98117) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36098')))))) 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` = 98117 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98153) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36191'))))) OR (((`item_id2` = 98153) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36191'))))) OR (((`item_id3` = 98153) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36191')))))) 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` = 98153 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91591) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1802-034'))))) OR (((`item_id2` = 91591) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1802-034'))))) OR (((`item_id3` = 91591) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1802-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` = 91591 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90752) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1724-034'))))) OR (((`item_id2` = 90752) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1724-034'))))) OR (((`item_id3` = 90752) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1724-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` = 90752 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98149) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36125'))))) OR (((`item_id2` = 98149) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36125'))))) OR (((`item_id3` = 98149) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36125')))))) 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` = 98149 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98148) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36126'))))) OR (((`item_id2` = 98148) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36126'))))) OR (((`item_id3` = 98148) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36126')))))) 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` = 98148 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94371) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35574'))))) OR (((`item_id2` = 94371) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35574'))))) OR (((`item_id3` = 94371) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35574')))))) 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` = 94371 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97842) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TD-0002-005'))))) OR (((`item_id2` = 97842) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TD-0002-005'))))) OR (((`item_id3` = 97842) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TD-0002-005')))))) 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` = 97842 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97841) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TD-0002-009'))))) OR (((`item_id2` = 97841) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TD-0002-009'))))) OR (((`item_id3` = 97841) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TD-0002-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` = 97841 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97840) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TD-0002-044'))))) OR (((`item_id2` = 97840) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TD-0002-044'))))) OR (((`item_id3` = 97840) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TD-0002-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` = 97840 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91783) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25150G4'))))) OR (((`item_id2` = 91783) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25150G4'))))) OR (((`item_id3` = 91783) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25150G4')))))) 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` = 91783 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 | |