SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516742 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516742 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677884,144368,476695,367089,720933,449320,1024484,196402,858994,238104,654815,804309,896378,926385,41271,977491,430435,927797,11853,957769,449918,813206,324199,751043,269449,376981,377046,546201,995930,882505,690382,981021,895853,187345,158723,677713,124576,979554,892069,360258,544228,844126,789093,219130,1036183,432224,1012092,302995,529432,198367,675785,801133,52102,276717,568137,954913,303137,266404,532152,221526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]