SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549511 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549511 [ RunTime:0.005142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205361,720858,923707,419698,814939,319780,364877,283905,485370,283292,683849,328009,516598,771808,694993,536994,295949,265514,672279,592796,813532,921082,891710,1002360,628043,641826,979240,663231,578074,630170,648887,707910,1047501,357986,736238,1007134,914601,252673,881823,1026343,1011255,572631,128177,445384,622411,608204,459844,377244,524876,426971,918784,191299,883843,274815,1039184,1009005,1042789,1029173,997372,686393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005398s ]