SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028992 LIMIT 1 [ RunTime:0.003968s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028992 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4170,705712,82912,407157,805046,344955,304351,620937,179992,576304,555663,153597,389937,404574,82342,6361,515084,308218,171719,515721,849892,484759,879300,166377,366765,885885,371066,780882,169435,153603,604383,120544,116326,523395,247974,46532,244433,70339,764677,612358,467513,39183,676309,991224,793835,205108,250350,465797,206556,945517,662132,690070,342730,727310,716170,749647,300912,599370,104741,268421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]