SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509365 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509365 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153443,161142,921565,953744,66569,469053,63617,541373,288709,851626,905354,819789,759336,430308,173988,455060,291187,379570,744096,642962,307190,284346,278437,711797,37639,736722,686970,798983,43067,670062,628555,837547,696396,261146,96059,245320,604747,914803,957554,276650,983227,205103,218628,707679,440089,136555,354562,820230,308836,1013314,725752,501460,145634,819114,41228,707999,367562,1007753,272843,92193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]