SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456878 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456878 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586809,321070,382259,1017511,260963,760852,84934,436794,1002897,671118,542506,52516,851980,143715,269085,42235,789991,345709,139723,850360,46322,240021,372506,955532,679105,368552,487418,945993,914251,383051,540493,305628,202003,987705,612682,832424,545656,770291,463721,922984,733208,349232,25749,487913,255825,440784,492855,416299,826150,884058,420909,812326,708157,915859,823732,401284,160449,702344,925544,323630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]