SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801410 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801410 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717693,162575,962258,541065,685930,132291,201444,882824,851673,815583,546534,686537,705352,648067,220225,66580,91214,904355,816633,580659,601830,922401,835635,389263,646396,621372,1013636,451248,619184,784680,170016,49112,134127,835681,779245,766217,653542,395239,563309,30533,928539,1039240,369327,198391,657636,698454,750102,256184,1032262,172216,527347,580934,413654,866987,237905,261485,113029,762944,604287,984925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]