SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028838 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028838 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736100,252256,50640,880538,1018809,183617,612426,8272,964569,903230,555988,1021954,579229,312600,121335,28767,661257,33277,890806,30185,976371,950123,760633,955316,711735,926685,380009,28739,746486,762679,834585,930535,281274,1036208,170095,708359,59390,786937,365102,556583,378035,872590,386887,978315,814402,257863,432069,238375,856084,314573,316710,610501,212495,692422,727565,1022287,302032,588000,908911,287340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002794s ]