SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021604 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021604 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712309,197791,559560,756645,887071,392381,246028,927842,432786,613662,419681,780638,40905,818086,806864,678110,109530,841975,428366,426766,783709,169193,87066,951042,322569,1036880,710322,919105,247209,73408,393436,536900,359652,427583,91163,338598,978737,883516,989056,800898,889993,646392,874617,406922,565469,675863,727461,775058,871803,640158,929723,131610,741307,75441,275707,525538,829,985585,261446,48260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]