SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430941 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430941 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458563,785887,175490,624041,873100,316624,175414,824617,454639,989253,54280,298590,613345,951030,885578,872525,212109,181873,666596,441327,490929,656350,441476,706362,262898,192791,210122,77392,700179,523322,788154,711921,765519,1011512,286707,175963,774052,670981,779006,15219,1017172,358398,978085,55315,705278,17481,239681,344818,422392,76826,190146,972080,678173,140103,896610,341228,777343,666936,568990,983441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]