SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30701 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30701 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558961,220957,989678,544231,864888,92586,622386,893387,43798,615118,1005375,222609,271262,362275,777257,825471,201194,987640,431845,133332,124177,86163,485070,281790,103425,691559,755061,128071,244461,463655,987880,458479,1030959,52664,275583,776117,131581,608477,774129,437154,88673,972291,504882,527529,55198,848740,132901,324032,335827,691683,958685,944135,365352,903239,760795,704362,105947,849641,589690,1044016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]