SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47509 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47509 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359717,447093,274981,418369,982319,301772,599299,971291,672468,29392,499418,125473,529424,988395,792046,209922,234427,452103,459454,609311,70977,666056,290121,227964,85106,877942,895943,736353,566098,312643,525846,106598,165524,643916,194524,1886,847855,695010,84480,514219,601711,812258,814108,482064,573417,395125,261333,500920,924692,113420,847400,594395,910246,207460,694654,48797,1025760,411981,477231,195648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]