SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420819 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420819 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576067,153746,946880,574365,75034,1001972,14970,114200,957539,654501,840503,1017115,797344,197419,856651,581054,499987,866054,269554,183643,76963,932637,523939,784675,222796,207416,306253,1005325,644705,569286,199219,267454,375992,512234,230420,706884,812189,213846,885958,71998,548199,78545,474565,595660,177150,608586,630973,707381,779383,657209,179500,408566,66170,80770,923146,221350,639691,42470,707941,747899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002625s ]