SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31900 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31900 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337253,4922,662620,766582,1001734,419489,389250,652499,579397,369806,619712,397693,1026036,862401,502696,668666,88897,1039724,566619,711367,241197,357701,148600,140864,157835,993202,189687,991133,561538,930375,234037,115972,962303,390684,476863,159694,593545,167384,247024,39132,888472,291086,273070,490674,296045,283810,391307,58848,1027432,475179,615732,497647,802701,50395,576950,396546,1011516,232366,113286,1046629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]