SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398102 LIMIT 1 [ RunTime:0.001716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398102 [ RunTime:0.003822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485467,1048151,322775,1008211,303785,1045422,434467,19125,244862,466199,681858,109906,1032103,348288,105589,217050,513315,1012569,545368,851376,969861,797560,377933,64634,514134,156461,409620,553201,827089,1000841,121999,786149,22322,119536,387363,51338,611864,514018,70234,955027,326318,969123,529093,609835,811170,687643,193792,248319,163447,749719,1025663,156248,175477,311913,911765,202217,86014,904251,658740,745932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]