SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540405 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540405 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260344,663679,841870,373616,1022514,410780,328522,11359,7555,744724,943381,681068,601146,635272,736026,631598,181865,305212,392542,873195,729672,281393,306670,638310,500905,949108,74189,843310,582182,542168,238048,320738,735610,1030641,974320,879372,31221,446143,605036,253982,649950,916579,981318,434164,837546,195991,800683,12648,623868,389399,473296,222170,297131,1006946,560884,860569,368731,272925,555943,243136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]