SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495429 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495429 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549308,706117,956437,250512,450202,628474,730245,158252,508472,235810,831194,140056,332557,416059,96319,197835,609125,413306,56050,650819,341748,1040202,244789,1013287,19780,883229,675583,363054,512689,278561,491548,485530,794921,312295,907673,943143,86851,200936,445688,482249,478879,595502,85348,435032,129923,267773,988114,168981,831458,683256,244876,605081,536515,336539,869116,305961,783266,919645,94174,613255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]