SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645473 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645473 [ RunTime:0.006403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535109,367613,538649,465582,48525,685932,593332,743180,999491,98730,317544,1014560,219435,418372,843392,723078,383942,252519,260390,19084,725756,606942,611150,691432,415832,485677,475901,918299,585649,584682,362198,609597,800960,605289,891441,245356,902740,122587,872988,275052,879305,1044085,395664,799868,536878,330262,824394,55328,123540,660720,982352,513742,24632,230877,507769,417896,163757,78301,79809,817314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]