SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039425 LIMIT 1 [ RunTime:0.001083s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039425 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722251,31291,316612,510916,759422,953958,761799,771254,404443,10927,718551,957981,223014,39858,1036726,527834,952158,1047515,129905,494336,158688,733802,635136,176978,100687,140229,639373,157398,464058,864503,891735,100270,387730,388037,873853,425185,61842,590340,238369,718821,290930,48005,1030214,34025,195889,194598,468456,12649,213575,394928,100867,14123,346504,660906,421528,28018,523960,286911,683541,718897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]