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 '%インテリア電波時計%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 183 | 183 | 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`.`id` IN (35695, 57695, 57696, 57697, 70489, 77330, 78017, 78018, 78019, 80097, 80609, 80609, 80610, 80610, 80611, 80611, 80729, 80730, 81109, 81109, 81109, 81216, 81216, 81229, 81245, 81496, 81497, 81498, 81499, 81499, 81500, 83796, 83796, 83812, 83813, 83942, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84517, 84518, 85798, 86049, 87783, 87784, 87785, 87786, 87919, 89033, 89034, 91336, 91393, 91394, 91480, 91488, 91800, 92300, 92769, 92994, 93591, 94253, 94253, 94254, 94254, 94357, 94358, 94509, 94510, 94511, 94512, 94571, 94572, 94613, 94614, 94615, 94616, 94743, 95313, 95314, 95315, 95316, 95372, 95414, 95610, 95613, 95634, 95635, 95636, 95637, 96355, 96450, 96855, 97686, 97687, 97693, 97694, 97695, 97696, 97805, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98148, 98148, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98628, 98666, 98796, 98908, 98909, 98911, 99246, 99755, 99756) 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 (35695, 57695, 57696, 57697, 70489, 77330, 78017, 78018, 78019, 80097, 80609, 80609, 80610, 80610, 80611, 80611, 80729, 80730, 81109, 81109, 81109, 81216, 81216, 81229, 81245, 81496, 81497, 81498, 81499, 81499, 81500, 83796, 83796, 83812, 83813, 83942, 84496, 84497, 84499, 84500, 84501, 84502, 84503, 84503, 84504, 84505, 84517, 84518, 85798, 86049, 87783, 87784, 87785, 87786, 87919, 89033, 89034, 91336, 91393, 91394, 91480, 91488, 91800, 92300, 92769, 92994, 93591, 94253, 94253, 94254, 94254, 94357, 94358, 94509, 94510, 94511, 94512, 94571, 94572, 94613, 94614, 94615, 94616, 94743, 95313, 95314, 95315, 95316, 95372, 95414, 95610, 95613, 95634, 95635, 95636, 95637, 96355, 96450, 96855, 97686, 97687, 97693, 97694, 97695, 97696, 97805, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98148, 98148, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98628, 98666, 98796, 98908, 98909, 98911, 99246, 99755, 99756) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98796) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2581G1'))))) OR (((`item_id2` = 98796) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2581G1'))))) OR (((`item_id3` = 98796) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2581G1')))))) 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` = 98796 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80097) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2573G1'))))) OR (((`item_id2` = 80097) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2573G1'))))) OR (((`item_id3` = 80097) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2573G1')))))) 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` = 80097 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94743) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2282930'))))) OR (((`item_id2` = 94743) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2282930'))))) OR (((`item_id3` = 94743) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2282930')))))) 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` = 94743 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 70489) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2559G4A'))))) OR (((`item_id2` = 70489) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2559G4A'))))) OR (((`item_id3` = 70489) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2559G4A')))))) 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` = 70489 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91480) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2373181'))))) OR (((`item_id2` = 91480) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2373181'))))) OR (((`item_id3` = 91480) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2373181')))))) 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` = 91480 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96855) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25159G5D'))))) OR (((`item_id2` = 96855) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25159G5D'))))) OR (((`item_id3` = 96855) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25159G5D')))))) 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` = 96855 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96355) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25124G7'))))) OR (((`item_id2` = 96355) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25124G7'))))) OR (((`item_id3` = 96355) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25124G7')))))) 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` = 96355 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95610) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25124G7'))))) OR (((`item_id2` = 95610) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25124G7'))))) OR (((`item_id3` = 95610) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25124G7')))))) 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` = 95610 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95613) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25124G7'))))) OR (((`item_id2` = 95613) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25124G7'))))) OR (((`item_id3` = 95613) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25124G7')))))) 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` = 95613 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81245) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-31757'))))) OR (((`item_id2` = 81245) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-31757'))))) OR (((`item_id3` = 81245) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-31757')))))) 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` = 81245 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94253) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-283840'))))) OR (((`item_id2` = 94253) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-283840'))))) OR (((`item_id3` = 94253) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-283840')))))) 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` = 94253 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94254) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-283949'))))) OR (((`item_id2` = 94254) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-283949'))))) OR (((`item_id3` = 94254) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-283949')))))) 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` = 94254 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92994) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2535G4'))))) OR (((`item_id2` = 92994) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2535G4'))))) OR (((`item_id3` = 92994) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2535G4')))))) 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` = 92994 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99755) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25153G2A'))))) OR (((`item_id2` = 99755) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25153G2A'))))) OR (((`item_id3` = 99755) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25153G2A')))))) 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` = 99755 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99756) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25153G2B'))))) OR (((`item_id2` = 99756) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25153G2B'))))) OR (((`item_id3` = 99756) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25153G2B')))))) 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` = 99756 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 | |