SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022489 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022489 [ RunTime:0.004196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792153,357468,165000,1036475,301655,286533,899147,744130,471413,196067,257840,99806,329674,594559,913089,787006,996142,857047,942669,637168,244966,937363,316345,220641,189464,443115,99618,39226,891554,1035389,158327,1028246,380346,56599,467396,202529,544319,960835,502306,157809,98993,146379,908227,106506,363403,835823,396755,576973,925908,1007202,102482,330099,590413,218955,901199,280317,282050,278040,87162,477445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]