SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035102 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035102 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048905,691555,676130,552965,779494,686008,564899,702592,754264,1024666,442673,530419,851734,7176,743523,613887,240969,191105,85517,871090,907756,446527,291161,702827,373408,756016,148671,178284,483016,48354,167000,905301,519846,731034,196322,487329,5725,826575,163148,587265,785512,553925,789981,425959,596249,930581,86905,25369,79145,851316,245342,1042765,649357,883352,272415,572362,102112,952847,618171,306194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]