SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398967 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398967 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717297,61239,442838,106606,920565,18051,760796,276151,428288,561180,279774,636329,591436,511068,370199,511885,614847,524739,116502,777661,397523,514380,181262,540066,1002404,431892,229591,116903,47147,745350,865884,101335,479747,362586,472887,340219,81804,829771,1012974,197910,649086,71062,24962,72677,972384,192027,684906,538085,575584,397864,64632,610338,519431,75701,761488,901109,117274,589971,198418,168165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]