SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005769s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402615 LIMIT 1 [ RunTime:0.001724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402615 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415848,1048720,736061,902753,524151,739276,470153,88723,661321,146110,167205,297283,693994,658836,1009007,571167,772298,748743,934647,360672,316082,208027,310656,331170,680258,973647,612139,884312,261593,211585,339040,625535,331337,405034,556754,911481,364101,602546,448543,234268,53744,223707,942450,837838,835832,264088,901230,609029,889880,55600,646135,451600,36279,435854,451724,921628,905069,560465,412546,896213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]