SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030289 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030289 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519947,137202,377053,813708,335201,383220,949166,638992,816826,500878,910399,627574,201241,1013459,534405,359474,681490,993307,297509,696799,400672,999358,983962,882911,285619,832207,915378,354623,266334,980386,196311,782431,366354,480334,886795,818363,482341,54542,785998,469055,385366,39515,993527,583449,531259,356422,654814,639114,968402,922237,106290,357411,982719,871248,633343,1700,379465,953174,629047,492373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]