SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939381 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939381 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048295,990550,719937,658387,298561,343158,716364,998600,825042,909627,568257,164649,625190,1038228,908545,789324,602051,1039106,999964,1016935,621681,370723,199099,50419,962633,671655,583692,779759,668905,524655,697629,442250,182545,146186,55608,643839,1000346,360016,114960,316023,505149,892965,5798,720723,102104,596840,995009,676071,38506,94407,539650,854245,259056,403614,106522,992902,639472,245386,784232,68001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]