SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405794 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405794 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560466,451004,401981,861760,1032040,466064,2919,676949,413708,254557,157031,915578,668645,293329,1035669,567292,853744,656446,692347,16789,426242,864096,678450,134869,458116,599251,766754,966007,86295,564770,73566,108471,962744,475496,953620,610144,99480,131502,760343,883424,865148,131093,135065,70196,851757,294733,760923,221045,833209,542832,890123,595741,835116,807382,496530,423526,543977,724166,858510,209175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]