SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326880 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326880 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209408,900470,456929,792906,1016896,427378,320490,559984,228080,80908,731857,488837,362573,613537,912182,980697,972840,383351,767443,889580,371310,675261,131337,912350,921549,742433,615527,424512,707892,166732,507477,963728,613667,57958,404443,140638,541699,568358,137480,79152,1015176,41436,983379,931067,610819,904527,623461,732344,472986,633113,448524,597280,882707,1024270,305597,196325,825635,260448,343916,478464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]