SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522810 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522810 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410327,382107,489636,504986,873048,668287,310954,170106,114465,150788,344471,395345,619448,150948,272237,674617,388957,754077,979932,316638,619478,802932,930131,871522,681355,240177,585325,658894,859115,300690,635455,702414,450180,489152,1002686,120978,311087,545416,263470,3329,230787,92148,865806,50279,271063,690856,1043701,843597,49717,273658,258772,268387,733476,693474,643729,687469,869814,408445,619249,174500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]