SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34844 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34844 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031212,590260,635832,862785,684270,791339,239620,192547,88052,556221,860125,109679,925103,121582,302885,183745,105446,175714,176815,984901,372107,215987,17570,9761,483042,596292,1039597,262524,832327,161148,412345,228655,798360,72411,950081,714193,230159,688822,1016390,767960,627452,473443,601668,680861,207748,237773,1046042,286826,710711,618603,649075,211506,338037,661550,819910,1042046,376648,991476,324264,982334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]