SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040522 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040522 [ RunTime:0.003046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903330,1012024,354534,307329,756197,4051,1031739,932360,796103,285454,73078,324066,105267,769304,184975,448680,68463,205561,1035254,762066,906346,489675,97892,977019,555832,337474,920022,143836,956819,496269,350380,855438,469995,250288,793237,728709,257693,96413,573236,410863,561506,337180,270019,150029,598795,531764,399883,266020,355985,429426,707392,731082,238671,704445,209496,634886,726789,695994,528682,765170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]