SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 832010 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 832010 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53999,895438,32756,579400,545176,1016710,483582,143041,643209,258758,928207,451870,1035847,666144,814878,510885,46584,933114,521711,460558,576991,770224,771538,869082,845657,410577,330697,352440,756796,503529,295835,123952,518921,993952,310180,883477,387086,653861,851410,380277,968362,960388,19135,600523,923642,71246,164646,191357,489077,425914,486284,690628,289924,705682,871399,660576,891765,618209,526418,914642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 832010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 832010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]