SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402453 LIMIT 1 [ RunTime:0.001120s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402453 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247981,92140,539130,648531,847209,615676,421898,73677,609167,339794,718828,201167,137352,22942,975512,316080,882417,33381,741543,194941,394798,294516,595366,300958,985177,751429,3199,910050,112792,35530,883262,452357,594846,7807,83618,789659,713368,74542,45756,414109,865878,364685,556425,557311,904426,732776,462221,987796,817819,821912,966971,281673,392589,186987,861633,490848,225023,1003540,381,161611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003362s ]