SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009854 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009854 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005049,408498,586648,661544,865088,496879,615015,669275,945808,890592,648737,687945,101627,119693,905175,70270,653400,914850,407848,875649,910205,973568,855044,868812,184048,68439,80541,953512,283840,922681,513973,369066,948377,285911,448049,794294,274832,304532,270903,714972,674185,273198,65155,851863,146161,564129,633260,757099,840143,721221,178220,714869,762905,221433,98329,576635,1006721,393351,485044,1011458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]