SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311306 LIMIT 1 [ RunTime:0.001340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311306 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482405,436466,304872,578079,350135,933031,734951,377749,928854,200706,364839,596267,730298,363554,158714,89873,758160,45071,118410,1046029,855974,653040,21408,449660,721228,507829,105606,388509,297382,472803,25072,666591,803913,404984,133201,717586,408403,711433,1007516,717229,229473,754805,440121,328490,905237,93695,393455,415010,11484,829717,418154,500310,257249,122528,319445,466993,880551,349575,341492,979908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]