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 '%プラス%') 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 | 168 | 168 | 0 | |
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_naming` = 1 AND `Item`.`id` IN (6173, 35724, 35724, 35725, 35725, 35726, 35726, 36770, 74432, 76778, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 84019, 84140, 84241, 84241, 84496, 84497, 84499, 84500, 84595, 84595, 84595, 84911, 84911, 85342, 85398, 85811, 86733, 87662, 87664, 87665, 87925, 88216, 88217, 88218, 89539, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90745, 90745, 90746, 90746, 91325, 91335, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91975, 91976, 91977, 92499, 92540, 92772, 92901, 93012, 93123, 93515, 94317, 94511, 94512, 95181, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95297, 95298, 95299, 95300, 95301, 95367, 95413, 95878, 95884, 95887, 95888, 96209, 96386, 96499, 96661, 96677, 96822, 96839, 96840, 96841, 96879, 96999, 97020, 97021, 97022, 97035, 97047, 97049, 97052, 97055, 97056, 97377, 97377, 98162, 98163, 98218, 98776, 98805, 98813, 98849, 98850, 98922, 99059, 99060, 99061, 99062, 99063, 99391, 99733, 99746, 99780, 99781) 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`.`item_naming` = 1 AND `Item`.`id` IN (6173, 35724, 35724, 35725, 35725, 35726, 35726, 36770, 74432, 76778, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 84019, 84140, 84241, 84241, 84496, 84497, 84499, 84500, 84595, 84595, 84595, 84911, 84911, 85342, 85398, 85811, 86733, 87662, 87664, 87665, 87925, 88216, 88217, 88218, 89539, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90745, 90745, 90746, 90746, 91325, 91335, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91975, 91976, 91977, 92499, 92540, 92772, 92901, 93012, 93123, 93515, 94317, 94511, 94512, 95181, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95297, 95298, 95299, 95300, 95301, 95367, 95413, 95878, 95884, 95887, 95888, 96209, 96386, 96499, 96661, 96677, 96822, 96839, 96840, 96841, 96879, 96999, 97020, 97021, 97022, 97035, 97047, 97049, 97052, 97055, 97056, 97377, 97377, 98162, 98163, 98218, 98776, 98805, 98813, 98849, 98850, 98922, 99059, 99060, 99061, 99062, 99063, 99391, 99733, 99746, 99780, 99781) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85342) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-242441'))))) OR (((`item_id2` = 85342) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-242441'))))) OR (((`item_id3` = 85342) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-242441')))))) 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` = 85342 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6173) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h144-033445'))))) OR (((`item_id2` = 6173) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h144-033445'))))) OR (((`item_id3` = 6173) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h144-033445')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 6173 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-033445FC'))))) OR (((`item_id2` = 74432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-033445FC'))))) OR (((`item_id3` = 74432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-033445FC')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 74432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91335) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2373031'))))) OR (((`item_id2` = 91335) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2373031'))))) OR (((`item_id3` = 91335) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2373031')))))) 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` = 91335 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88217) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1697-009'))))) OR (((`item_id2` = 88217) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1697-009'))))) OR (((`item_id3` = 88217) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1697-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` = 88217 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95301) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0120-044'))))) OR (((`item_id2` = 95301) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0120-044'))))) OR (((`item_id3` = 95301) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0120-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` = 95301 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96499) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25323G7'))))) OR (((`item_id2` = 96499) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25323G7'))))) OR (((`item_id3` = 96499) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25323G7')))))) 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` = 96499 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90676) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1730-030'))))) OR (((`item_id2` = 90676) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1730-030'))))) OR (((`item_id3` = 90676) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1730-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` = 90676 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98162) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36085'))))) OR (((`item_id2` = 98162) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36085'))))) OR (((`item_id3` = 98162) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36085')))))) 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` = 98162 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92499) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25310G3'))))) OR (((`item_id2` = 92499) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25310G3'))))) OR (((`item_id3` = 92499) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25310G3')))))) 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` = 92499 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95367) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846111'))))) OR (((`item_id2` = 95367) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846111'))))) OR (((`item_id3` = 95367) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846111')))))) 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` = 95367 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90674) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1730-008'))))) OR (((`item_id2` = 90674) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1730-008'))))) OR (((`item_id3` = 90674) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1730-008')))))) 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` = 90674 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92540) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25319G9'))))) OR (((`item_id2` = 92540) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25319G9'))))) OR (((`item_id3` = 92540) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25319G9')))))) 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` = 92540 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97377) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325240'))))) OR (((`item_id2` = 97377) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325240'))))) OR (((`item_id3` = 97377) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325240')))))) 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` = 97377 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95199) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0126-044'))))) OR (((`item_id2` = 95199) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0126-044'))))) OR (((`item_id3` = 95199) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0126-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` = 95199 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 | |