SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10344 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10344 [ RunTime:0.006743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76824,596127,569454,392448,96743,948941,213214,269012,234122,596430,22258,812181,557126,736846,724146,396725,165233,589107,786063,205402,388883,529967,78835,735379,398905,944866,664533,135562,498548,993498,10618,534498,665438,957593,69436,493375,188601,1024151,100251,392720,17898,660782,373129,53515,234864,202857,466223,620117,749076,613332,213423,168840,291108,461849,130972,675485,323400,416076,671038,935036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]