SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687512 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687512 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917828,709010,412015,739876,272760,203276,226913,945925,377137,825409,354193,80129,965170,855463,683602,1045616,743329,350044,878186,563763,790116,868239,1041089,427887,993937,836662,112111,824079,761995,942783,502943,644384,523019,596866,233211,75136,369272,486777,444370,59301,1047788,271883,941737,493399,923770,701785,2617,822627,93596,997933,184190,168422,670362,255300,590003,914575,395746,331802,666004,268194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]