SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283083 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283083 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207024,525593,816503,500290,15469,539588,272363,458115,1044733,137117,264606,246392,761430,992605,478148,49562,727601,718989,368894,130194,159052,189439,754909,78740,435991,93078,7551,899247,658803,98063,843561,682944,43545,46436,839408,878194,621003,737424,701231,627735,719211,478385,467925,219884,106431,109893,521325,276430,279735,237047,807491,897783,851692,943915,656155,999943,99358,546005,826377,1012401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]