SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22581 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22581 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113829,19819,477586,566101,436193,499222,1026090,509453,735428,1040972,935452,102124,523073,957351,15211,145515,31797,467212,883387,360771,682080,403376,74574,71454,300167,427053,722536,452235,1001298,764240,56763,679020,251867,864808,535922,982770,401446,931504,976820,822372,353018,509921,495474,742053,344336,974597,337347,1015882,97077,7597,446502,649159,673025,349061,430951,458991,120149,233167,366163,942966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]