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 '%MOTTERU%') OR (`Item`.`item_name` Like '%MOTTERU%') OR (`Item`.`item_figure` Like '%MOTTERU%') OR (`Item`.`item_color` Like '%MOTTERU%') OR (`Item`.`item_materials` Like '%MOTTERU%') OR (`Item`.`item_note` Like '%MOTTERU%') 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 | 117 | 117 | 365 | 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 (87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87327, 87328, 87329, 87330, 87331, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87405, 87406, 88176, 88177, 88178, 88179, 88180, 90440, 90441, 90442, 90443, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90758, 90759, 90760, 90761, 90762, 90763, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 95598, 95599, 95600, 95601) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 1 | 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 (87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87327, 87328, 87329, 87330, 87331, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87405, 87406, 88176, 88177, 88178, 88179, 88180, 90440, 90441, 90442, 90443, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90758, 90759, 90760, 90761, 90762, 90763, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 95598, 95599, 95600, 95601) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90758) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3015-888'))))) OR (((`item_id2` = 90758) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3015-888'))))) OR (((`item_id3` = 90758) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3015-888')))))) 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` = 90758 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90761) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3014-888'))))) OR (((`item_id2` = 90761) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3014-888'))))) OR (((`item_id3` = 90761) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3014-888')))))) 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` = 90761 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95601) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1207-028'))))) OR (((`item_id2` = 95601) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1207-028'))))) OR (((`item_id3` = 95601) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1207-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` = 95601 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95600) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1207-010'))))) OR (((`item_id2` = 95600) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1207-010'))))) OR (((`item_id3` = 95600) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1207-010')))))) 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` = 95600 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1208-028'))))) OR (((`item_id2` = 95599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1208-028'))))) OR (((`item_id3` = 95599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1208-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` = 95599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95598) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1208-010'))))) OR (((`item_id2` = 95598) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1208-010'))))) OR (((`item_id3` = 95598) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1208-010')))))) 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` = 95598 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90440) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-2003-030'))))) OR (((`item_id2` = 90440) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-2003-030'))))) OR (((`item_id3` = 90440) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-2003-030')))))) 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` = 90440 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90685) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3011-009'))))) OR (((`item_id2` = 90685) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3011-009'))))) OR (((`item_id3` = 90685) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3011-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` = 90685 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94717) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3016-058'))))) OR (((`item_id2` = 94717) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3016-058'))))) OR (((`item_id3` = 94717) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3016-058')))))) 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` = 94717 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94718) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3017-057'))))) OR (((`item_id2` = 94718) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3017-057'))))) OR (((`item_id3` = 94718) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3017-057')))))) 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` = 94718 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94716) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3016-059'))))) OR (((`item_id2` = 94716) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3016-059'))))) OR (((`item_id3` = 94716) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3016-059')))))) 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` = 94716 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94715) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3016-057'))))) OR (((`item_id2` = 94715) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3016-057'))))) OR (((`item_id3` = 94715) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3016-057')))))) 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` = 94715 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94714) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3030-044'))))) OR (((`item_id2` = 94714) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3030-044'))))) OR (((`item_id3` = 94714) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3030-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` = 94714 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94713) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3030-007'))))) OR (((`item_id2` = 94713) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3030-007'))))) OR (((`item_id3` = 94713) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3030-007')))))) 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` = 94713 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94712) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3022-028'))))) OR (((`item_id2` = 94712) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3022-028'))))) OR (((`item_id3` = 94712) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3022-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` = 94712 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 | |