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 `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`content`, `Gallery`.`url`, `Gallery`.`anchertext`, `Gallery`.`item_code1`, `Gallery`.`item_code2`, `Gallery`.`item_code3`, `Gallery`.`item_id1`, `Gallery`.`item_id2`, `Gallery`.`item_id3`, `Gallery`.`issue_date`, `Gallery`.`created`, `Gallery`.`modified` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE `Gallery`.`id` = 119 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` 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_code` = '13SC103' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 37 | maybe slow |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (45075) | 1 | 1 | 16 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 45075) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '13SC103'))))) OR (((`item_id2` = 45075) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '13SC103'))))) OR (((`item_id3` = 45075) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '13SC103')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 45075 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` 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_code` = '13SC108' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 29 | maybe slow |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (45107) | 1 | 1 | 15 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 45107) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '13SC108'))))) OR (((`item_id2` = 45107) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '13SC108'))))) OR (((`item_id3` = 45107) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '13SC108')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 45107 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` 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_code` = '13SC118' AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 28 | maybe slow |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (45050) | 1 | 1 | 19 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 45050) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '13SC118'))))) OR (((`item_id2` = 45050) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '13SC118'))))) OR (((`item_id3` = 45050) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '13SC118')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 45050 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`content`, `Gallery`.`url`, `Gallery`.`anchertext`, `Gallery`.`item_code1`, `Gallery`.`item_code2`, `Gallery`.`item_code3`, `Gallery`.`item_id1`, `Gallery`.`item_id2`, `Gallery`.`item_id3`, `Gallery`.`issue_date`, `Gallery`.`created`, `Gallery`.`modified` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE `Gallery`.`created` < '2013-04-12 17:48:09' ORDER BY `Gallery`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`content`, `Gallery`.`url`, `Gallery`.`anchertext`, `Gallery`.`item_code1`, `Gallery`.`item_code2`, `Gallery`.`item_code3`, `Gallery`.`item_id1`, `Gallery`.`item_id2`, `Gallery`.`item_id3`, `Gallery`.`issue_date`, `Gallery`.`created`, `Gallery`.`modified` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE `Gallery`.`created` >= '2013-04-11 00:19:06' AND `Gallery`.`created` != '2013-04-12 17:48:09' ORDER BY `Gallery`.`created` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` 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` = 45075 AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (45075) | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` 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` <> 45075 AND `Item`.`item_rank` = 1 AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 71 | maybe slow |
SELECT `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`category_id` = (41) | 331 | 331 | 16 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` 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` <> 45075 AND `Item`.`id` IN (44795, 44796, 44797, 44798, 44799, 44800, 44802, 44803, 44804, 44805, 44806, 44808, 44809, 44810, 44811, 44812, 44814, 44815, 44816, 44817, 44818, 44819, 44820, 44821, 44822, 44823, 44824, 44825, 44826, 44827, 44828, 44829, 44830, 44831, 44832, 44833, 44834, 44835, 44836, 44837, 44838, 44839, 44840, 44841, 44842, 44843, 44844, 44845, 44846, 44847, 44850, 44851, 44852, 44853, 44854, 44855, 44856, 44857, 44858, 44859, 44860, 44864, 44866, 44867, 44868, 44869, 44870, 44871, 44872, 44873, 44875, 44876, 44877, 44878, 44879, 44880, 44881, 44882, 44883, 44884, 44885, 44886, 44887, 44888, 44889, 44890, 44891, 44892, 44893, 44894, 44895, 44896, 44897, 44898, 44899, 44900, 44901, 44902, 44903, 44904, 44905, 44906, 44907, 44908, 44909, 44910, 44911, 44912, 44913, 44914, 44915, 44916, 44917, 44918, 44919, 44920, 44921, 44922, 44923, 44925, 44926, 44927, 44928, 44929, 44930, 44931, 44932, 44933, 44934, 44935, 44936, 44937, 44938, 44939, 44940, 44941, 44942, 44943, 44944, 44945, 44946, 44947, 44948, 44949, 44950, 44951, 44952, 44953, 44954, 44955, 44956, 44957, 44958, 44959, 44960, 44961, 44962, 44963, 44964, 44965, 44966, 44967, 44968, 44969, 44970, 44971, 44972, 44973, 44974, 44975, 44976, 44977, 44978, 44979, 44980, 44982, 44983, 44984, 44985, 44986, 44987, 44988, 44989, 44990, 44991, 44992, 44993, 44994, 44996, 44998, 44999, 45000, 45001, 45002, 45003, 45005, 45006, 45007, 45008, 45010, 45011, 45012, 45013, 45014, 45015, 45016, 45017, 45018, 45019, 45020, 45021, 45023, 45024, 45025, 45026, 45027, 45028, 45030, 44924, 44801, 44874, 44863, 44865, 44862, 44861, 44849, 45022, 45033, 45034, 45035, 45036, 45038, 45039, 45040, 45042, 45043, 45046, 45048, 45049, 45050, 45052, 45054, 45056, 45058, 45059, 45060, 45062, 45063, 45064, 45065, 45066, 45067, 45070, 45071, 45072, 45073, 45074, 45075, 45076, 45078, 45079, 45080, 45081, 45082, 45083, 45086, 45087, 45089, 45090, 45091, 45092, 45094, 45095, 45096, 45098, 45099, 45101, 45102, 45103, 45104, 45106, 45107, 45110, 45111, 45112, 45113, 45114, 45115, 45116, 45117, 45119, 45120, 45121, 45123, 45124, 45041, 45122, 45097, 45088, 45057, 45061, 45108, 45084, 45126, 45125, 45077, 45100, 45045, 45118, 45069, 45044, 45093, 45068, 45109, 45037, 45085, 45047, 44981, 45055, 45031, 45004, 44807, 44848, 45051, 45053, 45105, 45029, 44997, 44813, 44995, 45009) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 0 | 0 | 2 | maybe slow |
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 | |
SELECT `Gallery`.`issue_date`, `Gallery`.`title`, `Gallery`.`id`, `Gallery`.`content`, `Gallery`.`item_code1`, `Gallery`.`item_id1` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE 1 = 1 ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 2 | maybe slow |
SELECT `Item`.`item_name`, `Item`.`id` 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_code` = 'h015-030246' AND `item_rank` <> 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (6064) | 1 | 1 | 0 | |
SELECT `Item`.`item_name`, `Item`.`id` 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_code` = '14NK-105' AND `item_rank` <> 3 LIMIT 1 | 0 | 0 | 34 | maybe slow |
SELECT `Item`.`item_name`, `Item`.`id` 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_code` = 'h-109546' AND `item_rank` <> 3 LIMIT 1 | 1 | 1 | 16 | maybe slow |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (58324) | 1 | 1 | 17 | maybe slow |
SELECT `Item`.`item_name`, `Item`.`id` 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_code` = 'h177-040740' AND `item_rank` <> 3 LIMIT 1 | 0 | 0 | 0 | |
1 duplicate queries run.