SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682540 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682540 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711142,161131,391468,768900,1027150,809844,107788,1002159,652509,903909,23846,386050,276281,472814,94847,852467,988170,552626,1002744,656203,146901,114156,350946,367108,723786,693295,478706,246806,969586,485845,823974,396849,750845,814554,569109,303539,857197,318250,1022045,712379,298476,250903,694418,466989,1017705,301819,961477,435574,580728,1015265,581580,603973,881000,639523,268720,339128,1015082,21757,774275,954645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]