SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457948 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457948 [ RunTime:0.003882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866476,52212,618306,364643,447407,63052,69961,207636,247298,111690,485599,532791,406687,133270,1009593,595631,103596,933103,26107,745550,945280,606579,738571,567991,542352,198870,48306,772759,946326,999350,392345,365003,162432,626939,649302,534764,331011,300810,442464,581156,916602,972142,958180,586358,230517,609485,218727,996546,279375,114981,22196,441589,969734,808403,356985,353386,820083,968108,202139,831891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]