SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027051 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027051 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158238,115211,456923,838847,359610,290121,41558,481633,440401,835003,932739,522388,197814,568121,554499,487530,487440,786824,1788,363605,476564,229032,260346,521449,911984,265980,643207,181036,1036433,757434,205073,11384,548243,321481,447146,848375,573316,796453,847804,353601,589358,214992,147463,674934,1033715,529579,880426,1015698,669538,173593,536691,476731,889676,615253,709010,738791,476398,762536,748390,546301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]