SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50606 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50606 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564162,989139,519862,1043853,1008796,719291,602874,49981,579272,183806,1032879,315029,403456,690842,595055,318167,796943,303700,140810,498813,81733,1016519,665540,291292,598942,430087,297496,781909,93904,725248,328132,971407,953167,212688,239831,538880,213491,42084,359254,253511,870273,1044341,131945,576906,540823,633732,613097,878380,982335,713817,9130,647653,839201,277132,5177,840997,15725,15667,698792,163383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]