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 '%太陽の恵み瀬戸内だいだいぽん酢140ml%') OR (`Item`.`item_name` Like '%太陽の恵み瀬戸内だいだいぽん酢140ml%') OR (`Item`.`item_figure` Like '%太陽の恵み瀬戸内だいだいぽん酢140ml%') OR (`Item`.`item_color` Like '%太陽の恵み瀬戸内だいだいぽん酢140ml%') OR (`Item`.`item_materials` Like '%太陽の恵み瀬戸内だいだいぽん酢140ml%') OR (`Item`.`item_note` Like '%太陽の恵み瀬戸内だいだいぽん酢140ml%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 136 | 136 | 391 | 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_rank` = 1 AND `Item`.`id` IN (74944, 74948, 84061, 84084, 84091, 84093, 84106, 84257, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 88173, 89837, 90356, 90357, 91081, 91093, 91371, 91560, 91568, 93378, 93389, 93392, 93403, 93453, 93454, 93455, 94803, 94804, 95109, 95111, 95113, 95400, 95401, 95405, 96245, 96246, 96247, 96248, 96251, 96253, 96254, 96288, 97059, 97060, 97063, 97064, 97068, 97069, 97070, 97071, 97079, 97080, 97083, 97084, 97113, 97114, 97115, 97116, 97117, 97118, 97121, 97122, 97123, 97124, 97125, 97128, 97129, 97130, 97131, 97138, 97155, 97160, 97165, 97823, 97824, 97825, 97829, 97833, 97834, 98203, 98204, 98205, 98206, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98466, 98467, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98483, 98484, 99139, 99140, 99141, 99142, 99143, 99144, 99145, 99146, 99147, 99148, 99149, 99150, 99151, 99155, 99166, 99176, 99178, 99697, 99698, 99699, 99700, 99701, 99702, 99703, 99704, 99705, 99706, 99713) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 14 | 14 | 1 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89837) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25204G5'))))) OR (((`item_id2` = 89837) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25204G5'))))) OR (((`item_id3` = 89837) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25204G5')))))) 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` = 89837 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84091) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2578410'))))) OR (((`item_id2` = 84091) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2578410'))))) OR (((`item_id3` = 84091) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2578410')))))) 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` = 84091 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87272) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561310'))))) OR (((`item_id2` = 87272) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561310'))))) OR (((`item_id3` = 87272) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561310')))))) 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` = 87272 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87271) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561300'))))) OR (((`item_id2` = 87271) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561300'))))) OR (((`item_id3` = 87271) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561300')))))) 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` = 87271 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87274) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561320'))))) OR (((`item_id2` = 87274) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561320'))))) OR (((`item_id3` = 87274) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561320')))))) 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` = 87274 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 86060) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561140'))))) OR (((`item_id2` = 86060) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561140'))))) OR (((`item_id3` = 86060) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561140')))))) 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` = 86060 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 86059) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561110'))))) OR (((`item_id2` = 86059) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561110'))))) OR (((`item_id3` = 86059) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561110')))))) 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` = 86059 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 86057) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2563050'))))) OR (((`item_id2` = 86057) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2563050'))))) OR (((`item_id3` = 86057) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2563050')))))) 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` = 86057 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 86055) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561070'))))) OR (((`item_id2` = 86055) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561070'))))) OR (((`item_id3` = 86055) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561070')))))) 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` = 86055 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84061) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2563560'))))) OR (((`item_id2` = 84061) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2563560'))))) OR (((`item_id3` = 84061) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2563560')))))) 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` = 84061 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84257) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2562550'))))) OR (((`item_id2` = 84257) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2562550'))))) OR (((`item_id3` = 84257) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2562550')))))) 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` = 84257 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84093) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565840'))))) OR (((`item_id2` = 84093) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565840'))))) OR (((`item_id3` = 84093) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565840')))))) 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` = 84093 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84106) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2561210'))))) OR (((`item_id2` = 84106) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2561210'))))) OR (((`item_id3` = 84106) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2561210')))))) 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` = 84106 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84084) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2579830'))))) OR (((`item_id2` = 84084) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2579830'))))) OR (((`item_id3` = 84084) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2579830')))))) 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` = 84084 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 | |