SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681583 LIMIT 1 [ RunTime:0.001434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681583 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479475,2390,450853,112375,1008201,914779,697551,791162,618277,492587,205462,501064,916987,934501,1017789,886761,511018,366660,45856,940731,743511,1010111,117111,745333,435893,461669,202329,435021,204929,424267,194146,459958,542037,487341,586454,997504,839472,28326,111235,253035,572157,337060,617816,629643,55613,738368,809149,823886,472720,145402,3472,565036,135085,907604,364975,405969,322186,816105,742970,589747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]