SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029478 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029478 [ RunTime:0.002987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229043,1035860,137300,659123,135334,405804,158477,756365,659607,1030843,175755,988126,397038,607734,322087,621911,540393,916840,469466,534443,327051,259971,621457,937704,258258,1017270,882941,178948,683265,483611,894896,954110,329200,668692,232097,173806,505949,307739,823924,1020525,613094,324327,709855,581983,137839,80759,558812,638459,581130,372077,1037437,366188,161839,438212,559296,504772,105992,933893,534783,950687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]