SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499140 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499140 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18242,758650,661414,84567,471074,232040,70869,2024,725944,958593,54099,824649,908905,853675,841775,1012980,177285,877327,158122,672356,1852,581472,944462,843427,898796,560531,710673,784362,245723,722008,435444,202194,263066,700621,570292,320784,740229,584360,194755,371386,744533,128197,422117,743412,258231,1014892,991926,761790,806212,243853,637371,1020407,564209,615969,556291,442790,724542,98211,903369,669475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]