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 '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_name` Like '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_figure` Like '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_color` Like '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_materials` Like '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_note` Like '%カスタムデザインオーガニックコットンTシャツ7.4オンス%') OR (`Item`.`item_code` Like '%オーバーサイズ(XL)%') OR (`Item`.`item_name` Like '%オーバーサイズ(XL)%') OR (`Item`.`item_figure` Like '%オーバーサイズ(XL)%') OR (`Item`.`item_color` Like '%オーバーサイズ(XL)%') OR (`Item`.`item_materials` Like '%オーバーサイズ(XL)%') OR (`Item`.`item_note` Like '%オーバーサイズ(XL)%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 24 | 24 | 359 | 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 (95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` 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 (95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461) AND `item_rank` <> 3 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95456) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1402-028'))))) OR (((`item_id2` = 95456) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1402-028'))))) OR (((`item_id3` = 95456) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1402-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` = 95456 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95457) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1402-006'))))) OR (((`item_id2` = 95457) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1402-006'))))) OR (((`item_id3` = 95457) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1402-006')))))) 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` = 95457 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95458) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1402-009'))))) OR (((`item_id2` = 95458) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1402-009'))))) OR (((`item_id3` = 95458) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1402-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` = 95458 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95460) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1502-009'))))) OR (((`item_id2` = 95460) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1502-009'))))) OR (((`item_id3` = 95460) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1502-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` = 95460 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95459) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1402-044'))))) OR (((`item_id2` = 95459) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1402-044'))))) OR (((`item_id3` = 95459) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1402-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` = 95459 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95461) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1502-044'))))) OR (((`item_id2` = 95461) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1502-044'))))) OR (((`item_id3` = 95461) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1502-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` = 95461 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95438) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-0902-009'))))) OR (((`item_id2` = 95438) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-0902-009'))))) OR (((`item_id3` = 95438) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-0902-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` = 95438 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95440) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1002-028'))))) OR (((`item_id2` = 95440) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1002-028'))))) OR (((`item_id3` = 95440) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1002-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` = 95440 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95441) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1002-006'))))) OR (((`item_id2` = 95441) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1002-006'))))) OR (((`item_id3` = 95441) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1002-006')))))) 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` = 95441 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95442) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1002-009'))))) OR (((`item_id2` = 95442) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1002-009'))))) OR (((`item_id3` = 95442) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1002-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` = 95442 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95444) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1102-028'))))) OR (((`item_id2` = 95444) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1102-028'))))) OR (((`item_id3` = 95444) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1102-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` = 95444 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95445) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1102-006'))))) OR (((`item_id2` = 95445) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1102-006'))))) OR (((`item_id3` = 95445) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1102-006')))))) 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` = 95445 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95446) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1102-009'))))) OR (((`item_id2` = 95446) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1102-009'))))) OR (((`item_id3` = 95446) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1102-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` = 95446 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95448) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1202-028'))))) OR (((`item_id2` = 95448) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1202-028'))))) OR (((`item_id3` = 95448) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1202-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` = 95448 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95449) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TA-1202-006'))))) OR (((`item_id2` = 95449) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TA-1202-006'))))) OR (((`item_id3` = 95449) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TA-1202-006')))))) 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` = 95449 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 | |