SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32160 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32160 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791095,1008009,779655,598371,113302,394504,705064,645075,401949,36995,128312,52150,872942,1043669,702666,246920,254184,388988,638261,1040458,372248,455556,198666,179136,825742,367019,436701,360553,78345,846864,640395,1011324,1022934,1014816,179908,150280,907758,967138,830796,458843,777100,835358,93146,960994,662672,36244,481420,357320,146252,617573,42867,867545,912595,647876,1038339,542788,476309,20952,656639,343317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]