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 '%鶏野菜鍋つゆ720g%') OR (`Item`.`item_name` Like '%鶏野菜鍋つゆ720g%') OR (`Item`.`item_figure` Like '%鶏野菜鍋つゆ720g%') OR (`Item`.`item_color` Like '%鶏野菜鍋つゆ720g%') OR (`Item`.`item_materials` Like '%鶏野菜鍋つゆ720g%') OR (`Item`.`item_note` Like '%鶏野菜鍋つゆ720g%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 118 | 118 | 336 | 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 (74944, 74948, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 88173, 89837, 90356, 90357, 91093, 91371, 93378, 93389, 93392, 93403, 93453, 93454, 93455, 94803, 94804, 95111, 95113, 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, 97829, 97833, 97834, 98203, 98204, 98205, 98206, 98459, 98460, 98461, 98462, 98463, 98466, 98467, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 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 | 15 | 15 | 2 | 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 (74944, 74948, 86055, 86057, 86059, 86060, 87271, 87272, 87274, 88173, 89837, 90356, 90357, 91093, 91371, 93378, 93389, 93392, 93403, 93453, 93454, 93455, 94803, 94804, 95111, 95113, 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, 97829, 97833, 97834, 98203, 98204, 98205, 98206, 98459, 98460, 98461, 98462, 98463, 98466, 98467, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 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 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98463) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476779'))))) OR (((`item_id2` = 98463) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476779'))))) OR (((`item_id3` = 98463) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476779')))))) 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` = 98463 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98474) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476890'))))) OR (((`item_id2` = 98474) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476890'))))) OR (((`item_id3` = 98474) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476890')))))) 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` = 98474 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98462) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476778'))))) OR (((`item_id2` = 98462) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476778'))))) OR (((`item_id3` = 98462) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476778')))))) 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` = 98462 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98473) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565730'))))) OR (((`item_id2` = 98473) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565730'))))) OR (((`item_id3` = 98473) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565730')))))) 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` = 98473 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98461) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476777'))))) OR (((`item_id2` = 98461) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476777'))))) OR (((`item_id3` = 98461) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476777')))))) 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` = 98461 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98472) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565720'))))) OR (((`item_id2` = 98472) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565720'))))) OR (((`item_id3` = 98472) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565720')))))) 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` = 98472 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98460) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476776'))))) OR (((`item_id2` = 98460) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476776'))))) OR (((`item_id3` = 98460) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476776')))))) 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` = 98460 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98459) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476775'))))) OR (((`item_id2` = 98459) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476775'))))) OR (((`item_id3` = 98459) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476775')))))) 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` = 98459 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98479) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476903'))))) OR (((`item_id2` = 98479) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476903'))))) OR (((`item_id3` = 98479) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476903')))))) 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` = 98479 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98467) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565700'))))) OR (((`item_id2` = 98467) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565700'))))) OR (((`item_id3` = 98467) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565700')))))) 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` = 98467 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98478) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476902'))))) OR (((`item_id2` = 98478) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476902'))))) OR (((`item_id3` = 98478) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476902')))))) 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` = 98478 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98466) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476787'))))) OR (((`item_id2` = 98466) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476787'))))) OR (((`item_id3` = 98466) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476787')))))) 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` = 98466 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98477) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476901'))))) OR (((`item_id2` = 98477) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476901'))))) OR (((`item_id3` = 98477) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476901')))))) 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` = 98477 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98476) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476900'))))) OR (((`item_id2` = 98476) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476900'))))) OR (((`item_id3` = 98476) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476900')))))) 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` = 98476 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98475) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476891'))))) OR (((`item_id2` = 98475) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476891'))))) OR (((`item_id3` = 98475) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476891')))))) 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` = 98475 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 | |