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 | 216 | 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`.`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 `Cnt`.`pagecnt` 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`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 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77271) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-181245'))))) OR (((`item_id2` = 77271) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-181245'))))) OR (((`item_id3` = 77271) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-181245')))))) 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` = 77271 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73657) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1207-009'))))) OR (((`item_id2` = 73657) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1207-009'))))) OR (((`item_id3` = 73657) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1207-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` = 73657 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65209) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1147-044'))))) OR (((`item_id2` = 65209) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1147-044'))))) OR (((`item_id3` = 65209) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1147-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` = 65209 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80617) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-MEGS-S'))))) OR (((`item_id2` = 80617) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-MEGS-S'))))) OR (((`item_id3` = 80617) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-MEGS-S')))))) 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` = 80617 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80704) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1384-009'))))) OR (((`item_id2` = 80704) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1384-009'))))) OR (((`item_id3` = 80704) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1384-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` = 80704 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 78017) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-196041'))))) OR (((`item_id2` = 78017) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-196041'))))) OR (((`item_id3` = 78017) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-196041')))))) 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` = 78017 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80614) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-PUSG-S'))))) OR (((`item_id2` = 80614) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-PUSG-S'))))) OR (((`item_id3` = 80614) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-PUSG-S')))))) 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` = 80614 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-ST-A'))))) OR (((`item_id2` = 80609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-ST-A'))))) OR (((`item_id3` = 80609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-ST-A')))))) 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` = 80609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77220) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1309-044'))))) OR (((`item_id2` = 77220) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1309-044'))))) OR (((`item_id3` = 77220) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1309-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` = 77220 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 48176) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0935-044'))))) OR (((`item_id2` = 48176) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0935-044'))))) OR (((`item_id3` = 48176) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0935-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` = 48176 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73658) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1207-044'))))) OR (((`item_id2` = 73658) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1207-044'))))) OR (((`item_id3` = 73658) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1207-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` = 73658 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-LEGS-S'))))) OR (((`item_id2` = 80616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-LEGS-S'))))) OR (((`item_id3` = 80616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-LEGS-S')))))) 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` = 80616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80597) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-EX-B'))))) OR (((`item_id2` = 80597) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-EX-B'))))) OR (((`item_id3` = 80597) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-EX-B')))))) 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` = 80597 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80588) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-TW-A'))))) OR (((`item_id2` = 80588) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-TW-A'))))) OR (((`item_id3` = 80588) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-TW-A')))))) 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` = 80588 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-MAGS-S'))))) OR (((`item_id2` = 80615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-MAGS-S'))))) OR (((`item_id3` = 80615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-MAGS-S')))))) 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` = 80615 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 | |