SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282290 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282290 [ RunTime:0.003948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003714,233735,172582,511498,462171,832880,995902,603776,525646,471853,349252,229221,204128,660700,20797,335259,350235,354109,337444,512178,448939,380780,482912,664522,451403,867599,54187,259051,24205,446428,300517,1033079,50943,779082,997916,340737,627995,244507,420079,116964,815970,954245,776109,111283,709761,1013110,976133,313850,138036,980890,725375,1007769,964438,450595,271339,233286,868297,953320,9313,73930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]