SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545958 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545958 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869200,362278,79564,957816,421971,66924,1024224,693383,987142,213013,503915,443946,986299,1004305,716180,737947,849173,302392,260397,468906,940921,52809,469638,273992,101491,992029,90415,940622,820420,424599,325993,712820,579316,442278,92610,53950,835498,950951,698971,848952,452455,273630,881830,386389,311234,686542,994894,338421,990970,280060,133137,612478,631187,87832,188201,764490,48283,1023218,146615,460698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]