SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48133 LIMIT 1 [ RunTime:0.005361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48133 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549624,944823,201092,840129,203284,779409,961468,165063,545862,222788,370622,256907,577980,843511,876361,856540,642058,900033,378474,453520,4070,80442,773301,566869,662399,346295,467150,973381,437243,371628,868851,714241,112975,164246,809694,781540,336148,97804,508518,531669,787422,20131,81799,938804,693748,709853,674168,370832,471571,371321,852392,19783,611252,858505,200213,24100,353068,220925,620607,252069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001613s ]