SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537218 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537218 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954861,486010,863811,620486,823420,373944,760191,658796,1003015,553421,747458,259115,220263,69271,552706,659175,323513,778797,770600,72733,1033680,1025844,986014,791415,241532,78115,277947,474384,93334,504499,383471,871335,942957,174026,337717,681678,865977,205556,623757,985833,132591,884035,219373,324740,212726,1047263,533196,659223,800756,463389,646739,113654,843249,626140,755923,165028,526403,267981,46064,755911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]