SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116271 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116271 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47494,585700,766261,274540,421843,764996,818702,571808,321568,836992,166506,881488,957897,311456,1000421,171190,269206,878129,28353,136328,1047397,478212,1035164,365236,192314,61214,1002660,955952,987982,889846,758429,133217,99342,722784,264792,184858,577250,964379,196326,199924,142264,929706,472862,609866,1043830,547337,29085,46577,402735,959849,471767,988250,556417,693247,413481,210202,462580,566068,1033990,494444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]