SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6940 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6940 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419007,641816,753080,442820,680320,813990,22738,994169,150052,413757,1008813,49540,452487,222770,365750,646514,511076,430889,581994,189239,450830,922456,612557,639028,1015029,939117,718901,629694,611989,546174,491924,682721,683327,364892,7213,699557,503490,861716,665515,72455,348703,854783,83807,1012871,23025,1026433,306548,180047,601418,937908,566474,41100,263765,277148,987595,894650,814315,804693,479909,379121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]