SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523215 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523215 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56411,831542,542288,607954,611993,144979,914471,883412,442358,126575,934365,278355,170233,742401,75232,324739,289027,120038,373442,200005,449379,540549,80794,800120,98590,793574,625271,505057,182325,357483,308193,70682,631138,831273,591092,981284,467634,210889,623362,774686,131277,222916,627861,1020427,692290,410106,1019098,248893,202995,265276,783741,458641,591474,802817,336507,1006405,967693,900957,1011528,149061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]