SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468317 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468317 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6860,695112,561279,30514,7874,492964,623252,498885,174149,910438,684385,538851,443558,161890,326668,17570,742454,124204,750463,599063,268376,429095,428229,127402,749344,720876,231800,775873,19752,754899,612573,855585,824162,496089,216445,677424,394843,842373,906183,956657,539929,730898,426527,452928,452696,276309,212086,672333,412363,641527,643377,226126,1022268,797507,291354,983760,617175,455189,860420,11382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]