SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034068 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034068 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159230,987243,114592,629573,332588,866832,773920,80071,246023,826491,187093,584183,2536,351113,1025299,394205,454726,381600,339423,932045,507088,385025,306337,710041,77612,945412,739210,325289,87303,997541,476794,303322,469061,968068,572216,281970,573754,999775,995286,74295,780559,197263,378911,211659,613070,37814,1032409,180325,209605,637701,705862,207183,1018185,305239,989574,312250,71757,892637,837564,1012910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]