SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463610 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463610 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929414,714236,988210,289544,676477,407584,353294,322294,498346,116125,930253,748430,734508,447470,41345,775053,755180,435129,1030042,473134,831491,7767,152007,359989,345072,419040,416275,798522,278254,772003,303981,737002,795448,446949,817430,426541,524210,167270,36420,492103,560849,178865,861734,530258,968665,993929,850430,391367,776150,254877,857823,392085,585203,555937,357947,264902,566707,779383,1010444,872314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]